| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum If with two ranges and condition
Hy
I have to sum the values from A1:A100 if B1:B100="01-01-2006" and C1:C100="1" With only one it works like this sumif(B1:B100;"01-01-2006"; A1:A100), but I want some thing like this sumif(B1:B100;"01-01-2006"AND(C1:C100;"1"); A1:A100) Any help please |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do you count data that matches more than one condition? | Excel Worksheet Functions | |||
| multiple ranges on Vlookup | Excel Discussion (Misc queries) | |||
| Average Calculation | Excel Worksheet Functions | |||
| Counting Across Multiple Ranges, Based on Condition | Excel Worksheet Functions | |||
| how do i plot this kind of data using excel | Excel Discussion (Misc queries) | |||
Threaded Mode
