sum for date ranges

A

Anthony

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Date diffrence in days, weeks and months. 1
Countdown macro - display settings 2
Display weeks from a Milestone 0
Cumulative formula for word table 0
Use TODAY() function as the criteria in a SUMIF formula 1
Cobditional Formatting Rows based on dates in action plan. 0
Index and Match 5
How to sum values between dates 4

Top