Total Date data entries by Month

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do I fill out a table with month totals from an unsortable series of
entries by date. These are individual wages by date and I want to know what
the total wages bill is by month. I have tried SUMIF but am stuck on the
criteria.
 
=SUMPRODUCT(--(MONTH(A2:A20)=1,B2:B20)

etc.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
Hi Bob, When I sent this query first the system said it was not accepted. I
then sent the same query again as "Total Weekly Wages by Month" above -
sorry! My problem is that the totals for each employee interrupts the ranges
I should use. These individual (20) totals are more important than the totals
by month for wages so I am trying to incorporate both sets of figures in the
same sheet. I use different sheets for former years for comparison purposes
so I cannot create a Pivot Table Sheet. Any suggestions would be appreciated.
Bill
 

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

I still need help with formular? 2
Total weekly wages by month 9
Help with Date Range Formula 6
Totaling Volume within a range of dates 3
Need Help with Sumif Function including dates 6
SUMIF result including values not specified in sum-range 2
Month wise Sum 4
Excel Getting an annualized figure based on YTD in Excel 1

Back
Top