I have a database of information in excel and need a formula for compiling
totals and transferring it to the main worksheet page. Basically it is a
payment tracker - I put in todays date, account number, payment amount, etc
and hit submit - it then sends this info onto the next worksheet page (the
database). On the main page I have weekly, and monthly totals. I need it to
update the weekly monthly totals based on the actual week and month - not
last 7 days or last 30 days. How can i do this? Ultimately what it needs to
do is go to the second page and grab all the info for the current week
starting Monday and total up the payments and then bring it back to the main
page, and the same for the current month.

Thank you in advance!
--
na

Hi!

To sum values that fall into the current week: (current week is Monday thru
Sunday)

=SUMIF(Dbase!A1:A10000,"="&TODAY()-WEEKDAY(TODAY(),3),Dbase!B1:B10000)-SUMIF(Dbase!A1:A10000,""&(TODAY()-WEEKDAY(TODAY(),3))+6,Dbase!B1:B10000)

To sum values that fall into the current month:

=SUMPRODUCT(--(MONTH(Dbase!A1:A10000)=MONTH(TODAY())),Dbase!B1:B 10000)

Biff

"Cody" wrote in message
...
I have a database of information in excel and need a formula for compiling
totals and transferring it to the main worksheet page. Basically it is a
payment tracker - I put in todays date, account number, payment amount,
etc
and hit submit - it then sends this info onto the next worksheet page (the
database). On the main page I have weekly, and monthly totals. I need it
to
update the weekly monthly totals based on the actual week and month - not
last 7 days or last 30 days. How can i do this? Ultimately what it needs
to
do is go to the second page and grab all the info for the current week
starting Monday and total up the payments and then bring it back to the
main
page, and the same for the current month.

Thank you in advance!
--
na

Thankyou, do you know how I would also do the same thing but instead of
adding up the totals it would count how many payments were made for the week
and also another one for how many for the month... thank you... i appreciate
your help.
--
na


"Biff" wrote:

Hi!

To sum values that fall into the current week: (current week is Monday thru
Sunday)

=SUMIF(Dbase!A1:A10000,"="&TODAY()-WEEKDAY(TODAY(),3),Dbase!B1:B10000)-SUMIF(Dbase!A1:A10000,""&(TODAY()-WEEKDAY(TODAY(),3))+6,Dbase!B1:B10000)

To sum values that fall into the current month:

=SUMPRODUCT(--(MONTH(Dbase!A1:A10000)=MONTH(TODAY())),Dbase!B1:B 10000)

Biff

"Cody" wrote in message
...
I have a database of information in excel and need a formula for compiling
totals and transferring it to the main worksheet page. Basically it is a
payment tracker - I put in todays date, account number, payment amount,
etc
and hit submit - it then sends this info onto the next worksheet page (the
database). On the main page I have weekly, and monthly totals. I need it
to
update the weekly monthly totals based on the actual week and month - not
last 7 days or last 30 days. How can i do this? Ultimately what it needs
to
do is go to the second page and grab all the info for the current week
starting Monday and total up the payments and then bring it back to the
main
page, and the same for the current month.

Thank you in advance!
--
na