Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
"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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
"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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
"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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
"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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Multiple Criteria | Excel Worksheet Functions | |||
Counting by multiple criteria | Excel Worksheet Functions | |||
Multiple Criteria (add or subtract) | Excel Discussion (Misc queries) | |||
Multiple Criteria IF Nesting | Excel Worksheet Functions | |||
Can I get the mode, min, and max with multiple criteria? | Excel Discussion (Misc queries) |