Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Total Date data entries by Month
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Total Date data entries by Month
=SUMPRODUCT(--(MONTH(A2:A20)=1,B2:B20)
etc. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "BillMcSweeney" wrote in message ... 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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Total Date data entries by Month
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 "Bob Phillips" wrote: =SUMPRODUCT(--(MONTH(A2:A20)=1,B2:B20) etc. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "BillMcSweeney" wrote in message ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
macro | Excel Discussion (Misc queries) | |||
Counting the number of date entries in a giving month | Excel Discussion (Misc queries) | |||
Vlookup to Return a Range of Data | Excel Discussion (Misc queries) | |||
How do I sort data by Month on the date format like (02/04/97)? | Excel Discussion (Misc queries) | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions |