Check your absolute/relative reference, they are not consistent. Also, if
you put the "--" in front of each test (so all but the last one), I think the
formula works better.

"sahafi" wrote:

While this formula works on another sheet, it doesn't work on this sheet.
Actually it works only on first cell. I have tried copy paste special
formula, I also tried drag the formula down, but nothing seem to work. I have
checked the data format for each column, I even used 'substitute with char
160, but nothing will work. Here's my formula:

SUMPRODUCT(--(Data!$A$2:$A$12000=Report!$C$1)*(Data!$B$2:$B$120 00=Report!$A10)*(Data!$C$2:$C$12000=Report!$B10)*( Data!$E$2:$E$12000=Report!$C$2)*(Data!$F$2:$F$1200 0))

'Report' is where my formula is, and 'Data' sheet where's my data resides.

Any help is greatly appreciated.

Oz

Thanks.
--
when u change the way u look @ things, the things u look at change.