"sumif" With Multiple Criteria!
 

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


--
via135
------------------------------------------------------------------------
via135's Profile: http://www.excelforum.com/member.php...o&userid=26725
View this thread: http://www.excelforum.com/showthread...hreadid=502163

"sumif" With Multiple Criteria!
 

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

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

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

Hope this helps.

Pete

"sumif" With Multiple Criteria!
 

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



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

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

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

Hope this helps.

Pete


--
via135
------------------------------------------------------------------------
via135's Profile: http://www.excelforum.com/member.php...o&userid=26725
View this thread: http://www.excelforum.com/showthread...hreadid=502163

"sumif" With Multiple Criteria!
 

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