SUMIFS

  • Thread starter Thread starter RAK
  • Start date Start date
R

RAK

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
 
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?
 
1) Check whether the AN3:AN997 numbers are formatted as Text.
2) Check whether AN3:AN997 numbers are entered with a leading single quote.
3) Check whether C3:C997 range is having the Value “ARC†with any leading or
preceding spaces.
4) Check whether D3:D997 range is having the Value “EOC†with any leading or
preceding spaces.

If all the above is perfect then the formula will run perfectly.

Remember to Click Yes, if this post helps!
 
RAK said:
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
AN is formatted as numbers (format cell>Number>Number>positive 1234.0 w/o ( )
Click to expand...
 
Ron Rosenfeld said:
It is quite possible that the values in AN3:AN997 are text and not
numbers.

How are those values generated?

You can use the ISNUMBER (or ISTEXT) commands to see how Excel is
interpreting these values.

If they are being generated by a formula, you'll need to ensure the
formula is outputing numbers and not text.

If they were input manually, or copied from some other source, you
will need to convert them to numbers. This can be done easily,
depending on how the values have been entered.
.
ISNUMBER shows true that it is a number - it is generated by a formula
Click to expand...
 
Dave Peterson said:
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?


--

Dave Peterson
.
They appear to be numbers by cell format screen and return of true value fromISNUMBER
Click to expand...
 
Ms-Exl-Learner said:
1) Check whether the AN3:AN997 numbers are formatted as Text.
2) Check whether AN3:AN997 numbers are entered with a leading single quote.
3) Check whether C3:C997 range is having the Value “ARC†with any leading or
preceding spaces.
4) Check whether D3:D997 range is having the Value “EOC†with any leading or
preceding spaces.

If all the above is perfect then the formula will run perfectly.

Remember to Click Yes, if this post helps!
Click to expand...
 
Then check the values in the other fields. Maybe they're not what you're
looking for.
 
Back
Top