June 4th, 2010, 06:03 PM
posted to microsoft.public.excel.misc
|
|
SUMIFS
"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",D3997,"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
|