Then check the values in the other fields. Maybe they're not what you're
looking for.

RAK wrote:

"Dave Peterson" wrote:

Maybe the value in AN3:An997 aren't really numbers. Maybe they're just text
that looks like numbers.

If you put:
=count(an3:an997)
in a cell
and
=counta(an3:an997)
do those evaluate to the same result?

And a silly suggestion...

Are you sure you're using the correct columns?

RAK wrote:

My SUMIFS formula was "accepted" but the result is 0.0 even though there are
numbers to add. What can the problem be?
The formula is =SUMIFS(AN3:AN997,C3:C997,"ARC",D3:D997,"EOC")
I want the total form column AN when column C is ARC and when column D is EOC

--

Dave Peterson
.
They appear to be numbers by cell format screen and return of true value fromISNUMBER

--

Dave Peterson