how to create weekly totals

K

Kamra

I would like to create a worksheet that gives a weekly total for each of my
teams call stats. That would then generate a monthend total for each team.
Any suggestions ???--
justproverbs
 
D

Don Guillett

for week
SUMPRODUCT((A1:A33>=DATE(2009,1,11))*(A1:A33<=DATE(2009,1,17))*b1:b33)
for month
=sumproduct((month(a1:a33)=1)*b1:b33)
 

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

How to implement two shifts per day with multiple teams 0
Integrating information from Word to Excel (not mail merge) 1
Request Form - Alert Team Member 0
Incone & Expenses Statement 0
Sports summary sheet - think I put this in wrong place originally 1
Shared Link is showing empty notebook 1
Formula help needed please 2
How to automate update on weekly reports spreadsheet 0

Top