asked on Using SUMPRODUCT with a Date Range
I'm trying to sum the number of dates with in a range for a given document type using SUMPRODUCT in the attached example spreadsheet.
I can get the formula to return the correct value for a single date, but I want to sum over a range of dates, specifically the entire week.
The formula is in Summary!C2. I thought =SUMPRODUCT(--(Dates!A2:A3
What am I missing?
Thank you!
Test-Spreadsheet-MV.xlsx
I can get the formula to return the correct value for a single date, but I want to sum over a range of dates, specifically the entire week.
The formula is in Summary!C2. I thought =SUMPRODUCT(--(Dates!A2:A3
What am I missing?
Thank you!
Test-Spreadsheet-MV.xlsx
Microsoft OfficeMicrosoft ExcelSpreadsheets
Last Comment
Michael Vasilevsky
SUMPRODUCT is a function used to add (SUM) a range of multiplications (PRODUCTS)
How are you planning on multiplying dates?
I thought long and hard before replying - I don't think I am missing something? Your source data are dates - SUMPRODUCT won't apply!
How are you planning on multiplying dates?
I thought long and hard before replying - I don't think I am missing something? Your source data are dates - SUMPRODUCT won't apply!
I think you want to COUNT the dates and not SUM (add them)
I already noticed and gave him CountIF option
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Thank you!
Test-Spreadsheet-MV_v1.xlsx