ExcelBanter - View Single Post - what formula would I use to add information in a range of dates?

Bob Phillips

You could use SUMIF, as an example

=SUMIF(date_range,"="&start_date,number_range)-SUMIF(date_range,"="&start_date+7,number_range)

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Peggy" wrote in message
...
I am trying to add income from the days of one work week together. I then
want to build my spreadsheet so I can look at different weeks in a month.
I
thought I would build in a button to give me this option to either view
the
information daily or weekly. The hardest bit is trying to build a formula
that's cleaver enough to give me this weekly information? Also when two
months merge together for example March 30th - 5th April. Any thoughts of
where I begin?

__________ Information from ESET Smart Security, version of virus
signature database 3832 (20090206) __________

The message was checked by ESET Smart Security.

http://www.eset.com

__________ Information from ESET Smart Security, version of virus signature database 3832 (20090206) __________

The message was checked by ESET Smart Security.

http://www.eset.com