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",D3997,"EOC")
I want the total form column AN when column C is ARC and when column D is EOC
--
Dave Peterson