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