Help please, IF statement/SUMIF statement

[Guest]

Hi,

If the Cell Format is correct, the F9"-Error Search" don't give any strange
values; Reduce the formula (fewer criterias or rows) until it start to work.
If it still don't work, try to rewrite every Text and Number - in your test
sample.

Ola

 

[Guest]

Ola,

I hit F9 and it didn't do anything. I also condensed the formula down to
the following:


=SUMPRODUCT(--(Test!B2:B5=I5),--(Test!C2:C5=K5),--(Test!E2:E5=O5),Test!I2:I5)

This is still leaving - in the cell.

 

[Guest]

Brad,

Try and ask a new question.
"How can SUMPRODUCT give me - as an answer?"

Ola

 

[JulieD]

Hi Brad

okay with text values in B2:B5, and C2:C5 and E2:E5 and numeric values in
I2:I5 on a sheet called test
and with the criteria in I5, K5, O5 of the current sheet it worked for me.

are you sure that there are not things like trailing spaces in you ranges
which means that nothing matches the criteria?
if you've using ver 2002 / 2003 what does running the formula through tools
/ formula auditing / evaluate formula show?

Cheers
JulieD