View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
jana jana is offline
external usenet poster
 
Posts: 18
Default Sumproduct with conditions - urgent help needed

I have a sumproduct in my spreadsheet =sumproduct(N8:N13,I8:I13) that works
fine. However, I need to add a condition to this. If F8:F13="XYZ". How do
I change the sumproduct to only calculate if column F contains "XYZ"?

Your help would be greatly appreciated - under a tight deadline for a client!
Jana