SUMIF finds data when Criteria is blank

E

emea training 2

When using the SUMIF formula and referencing the Criteria to a blan
cell, a result is still returned? I would have thought that it woul
have given me an N/A or REF

However, this value is not in the Sum Range - does anyone know what i
is?

:confused
 
B

Bob Phillips

What formula are you using, and what does the data look like?

Make sure that the cell is blank, not spaces.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"emea training 2"
 
T

Tim M

Not 100% clear here. you have a column of data, some cells have numbers and
some cells are blank. You do a sumif only the blank cells. In my little
test I got a result of 0 as expected when I did that.
 
Top