Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
So I can't get the formula below to work. Any suggestions?
For reference, the sheet with all the data is called "All Movements". From that sheet I want to sum all the figures in column E that match with the name "Mike" in column D, and the province abbreviation "AB" in column O. =SUMPRODUCT(--('All Movements'!D:D="Mike"),--('All Movements'!O:O="AB"),'All Movements'!E:E) Right now I get #NUM error in the cell. Thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
SUMPRODUCT PROBLEM | Excel Worksheet Functions | |||
Problem using ADDRESS() in SUMPRODUCT() | Excel Discussion (Misc queries) | |||
Frustrating SUMPRODUCT problem. | Excel Discussion (Misc queries) | |||
SUMPRODUCT Problem | Excel Discussion (Misc queries) | |||
SUMPRODUCT problem | Excel Worksheet Functions |