View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
juliejg1 juliejg1 is offline
external usenet poster
 
Posts: 81
Default SUMPRODUCT question

I am looking at four columns:

A1 = Scorecard Date
B1:B20 = Different dates
D1:D20 = Record Value
E1:E20 = Spend

I would like to do the following:
For all records where the dates in column B match the date shown in A1, I
would like to sum D1:D20 and divide the total by the sum of E1:E20.