Sumproduct problem...
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.
|