I have a sheet linked to a cell containing SUMPRODUCT formula (like "=SUMPRODUCT(--(dealer_List=A6),(claims_recd),--(Data_List>=$B$2),--(Data_List<=$D$2))".

"claims_recd" is NAME i have given to a column and have some basic IF formula for gettng value.

I am getting "0" value in the cell which contain SUMPRODUCT formula even if there is a number greater than 0 in the cells. If I type numbers manually, I get the required result in the cell with SUMPRODUCT formula.

Can sombody help please?

Thanks a lot.

The formula looks good. Are the named ranges Data_List and Dealer_List both the same number of rows deep?

Post up a sample worksheet with your formula in it and misbehaving, point out where that is and I'll take a look.

Thank you for your reply.
I was able to catch the error - it was in the assigning of name.
Now it is working all right.