| 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 |
| 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) | |||
Threaded Mode
