Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMIF with two condition from two ranges
I want to sum the cells in D5:D64 where B5:B64="AA", and where E5:E64<"".
So again, I would like it to check for the cells in Column B that = "AA" and of those check if Column E that < "" and add the cells in column D that meet both conditions. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sumif condition | Excel Worksheet Functions | |||
Sum If with two ranges and condition | Excel Worksheet Functions | |||
SumIF for more than one condition | Excel Worksheet Functions | |||
Sumif, having two condition | Excel Worksheet Functions | |||
Counting Across Multiple Ranges, Based on Condition | Excel Worksheet Functions |