I'm just not sure whether this is possible or not.

Can I create a function that goes as below:

=SUMIF(IF(......),Z,A:A)

It seems when I insert an IF statement inside a SUMIF statement, Excel
returns #VALUE! If this is not allowed, how do I get around this problem?

Hi,
the sumif already has the criteria, what do you want to achieve, please post
an example

"Sungibungi" wrote:

I'm just not sure whether this is possible or not.

Can I create a function that goes as below:

=SUMIF(IF(......),Z,A:A)

It seems when I insert an IF statement inside a SUMIF statement, Excel
returns #VALUE! If this is not allowed, how do I get around this problem?

=SUMIF(IF(......),Z,A:A)

SUMIF can't be used like that.

Try explaining in words what you want to do.

--
Biff
Microsoft Excel MVP


"Sungibungi" wrote in message
...
I'm just not sure whether this is possible or not.

Can I create a function that goes as below:

=SUMIF(IF(......),Z,A:A)

It seems when I insert an IF statement inside a SUMIF statement, Excel
returns #VALUE! If this is not allowed, how do I get around this problem?

you may have you criteria in the wrong order

SUMIF(range, criteria, [sum_range]) is the correct format.

Your IF statement would need to evaluate to a range (both when true or
false) to work as you have written your formula. It is possible to have a if
statement return a range (using the offset function would work), but there is
likely an easier way.

You did not provide much detail so I cannot give you a definate answer, but
can offer the following advice.

If you wish to sum something based on multiple criteria (for example sum up
all values in c1:c10 where column A=1 and B="Yes") you could do this in two
ways.

If you have Excel 2007 use the SUMIFS function which allows for multiple
criteria or
use a sumproduct function with conditions.

the formula =Sumproduct(--(A1:a10=1),(b1:b10="Yes"),C1:C10) would work.
--
If this helps, please remember to click yes.


"Sungibungi" wrote:

I'm just not sure whether this is possible or not.

Can I create a function that goes as below:

=SUMIF(IF(......),Z,A:A)

It seems when I insert an IF statement inside a SUMIF statement, Excel
returns #VALUE! If this is not allowed, how do I get around this problem?