View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] cjwenngatz@gmail.com is offline
external usenet poster
 
Posts: 9
Default 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.