software

hi

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

608070
503040
204070
1006080

what i want is the sum C1:C4 if either quot;A1gt;=50 *or* A4lt;100quot;, likewise
quot;A2=50 *and* A4=100quot;..and so on!

help pl?

-via135--
via135
------------------------------------------------------------------------
via135's Profile: www.excelforum.com/member.php...oamp;userid=26725
View this thread: www.excelforum.com/showthread...hreadid=502163You don't need SUMIF( ) - try this:

=IF(OR(A1gt;=50,A4lt;100),sum(C1:C4),IF(AND(A2=50,A4=1 00),sum(C1:C4),0))

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

Hope this helps.

Pete
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 quot;..and so onquot;. that's all!

-via135
Pete Wrote:
gt; You don't need SUMIF( ) - try this:
gt;
gt; =IF(OR(A1gt;=50,A4lt;100),sum(C1:C4),IF(AND(A2=50,A4=1 00),sum(C1:C4),0))
gt;
gt; I don't know what you mean by quot;..and so on!quot;
gt;
gt; Hope this helps.
gt;
gt; Pete--
via135
------------------------------------------------------------------------
via135's Profile: www.excelforum.com/member.php...oamp;userid=26725
View this thread: www.excelforum.com/showthread...hreadid=502163The arrangement of functions shown above is referred to as quot;nestingquot;,
and there is a limit to the amount of nesting that Excel allows -
maximum of 8 nested functions.

Pete