On Fri, 4 Jun 2010 07:38:33 -0700, 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

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.