| 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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
SUMIF with two condition from two ranges
=sumproduct(--(b5:b64="AA"),--(E5:e64<""),d5:d64)
"JBoyer" wrote: 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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
SUMIF with two condition from two ranges
=SUMPRODUCT((B5:B64="AA")*(E5:E64<"")*(D5:D64))
"JBoyer" wrote in message ... 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. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
SUMIF with two condition from two ranges
Thanks, that worked perfect!
"Duke Carey" wrote: =sumproduct(--(b5:b64="AA"),--(E5:e64<""),d5:d64) "JBoyer" wrote: 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. |
| Reply |
| 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 | |||
Linear Mode
