ExcelBanter - sum for date ranges

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - sum for date ranges (https://www.excelbanter.com/excel-discussion-misc-queries/246891-sum-date-ranges.html)

Anthony

sum for date ranges

hi

culoumn a is date

column b is numbers

c1 cell is a report as at today input

how do i write a formula to sum the contents of column B based on there date
been in the last 7 days from report date

T. Valko

sum for date ranges

One way:

=SUMPRODUCT(--(A1:A10=C1-7),--(A1:A10<=C1),B1:B10)

--
Biff
Microsoft Excel MVP

"Anthony" wrote in message
...
hi

culoumn a is date

column b is numbers

c1 cell is a report as at today input

how do i write a formula to sum the contents of column B based on there
date
been in the last 7 days from report date

All times are GMT +1. The time now is 07:19 AM.