"sumif" With Multiple Criteria!

[via135]

hi

can i sumup a full column list using "sumif", with more than one criteria, all based on a single coloum? for example i am having data in A1:C4

60 80 70
50 30 40
20 40 70
100 60 80

what i want is the sum C1:C4 if either "A1>=50 or A4<100", likewise "A2=50 and A4=100"..and so on!

help pl?

-via135

[Pete]

You don't need SUMIF( ) - try this:

=IF(OR(A1>=50,A4<100),sum(C1:C4),IF(AND(A2=50,A4=100),sum(C1:C4),0))

I don't know what you mean by "..and so on!"

Hope this helps.

Pete

[via135]

thks Pete!

i had given only two examples of multiple criteria with two conditions. can i give any number of criterias with more than two conditions?..that's why i have mentioned "..and so on". that's all!

-via135

You don't need SUMIF( ) - try this:

=IF(OR(A1>=50,A4<100),sum(C1:C4),IF(AND(A2=50,A4=100),sum(C1:C4),0))

I don't know what you mean by "..and so on!"

Hope this helps.

Pete

[Pete]

The arrangement of functions shown above is referred to as "nesting",
and there is a limit to the amount of nesting that Excel allows -
maximum of 8 nested functions.

Pete