Help please, IF statement/SUMIF statement

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
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.
 
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
 
Back
Top