Stubborn SUMIF

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to get the following function to behave. It
is returning a value of zero, which is incorrect. The
criteria and comparison range data are formatted as
dates. It seems to hate the criteria cell reference.
Will it only work with some text or other value as the
criteria? Thanks for your help.

=SUMIF(E3:E75,">A82",G3:G75)
 
SUMIF, COUNTIF andother functions do not accept the less than or more than
operators.
If you say ">"A82 which is saying greater than and A82 it works, I don't
really know why to be honest.
Ask a Microsoft programmer would be the best bet I would think! <bg>
Regards,
Alan.
 
Hi Peo,

Do you know why COUNTIF accepts ">82" without seeing it as a string?

I have always wondered,

Regards

Sandy
 
I can only speculate that it is because countif/sumif really don't make any
difference between
numeric and text in the criteria . Test:

put numeric ones in A1:A10

1
1
1
etc

notice that both these formulas return the same result

=COUNTIF(A1:A10,1)

=COUNTIF(A1:A10,"1")

now if you change the ones to text numeric by preceding them with an
apostrophe
both formulas will still return the same result

while for instance if you use sumproduct

=SUMPRODUCT(--(A1:A10="1"))

and

=SUMPRODUCT(--(A1:A10=1))

will return different result.

I have stopped using countif as a check when using vlookups due to that,
now I use isnumber and match
 
Back
Top