Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
subtotals
Hello,
I have a list of dollar amounts corresponding with days in the months. I am trying to create a subtotal for each month and not each day of the month. When I do subtotal I get a subtotal for each day of the month. How do I get a total just for the month? Thanks, Chris |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
subtotals
try this for the month (if dates in col a) and data to sum in col b
=sumproduct((month(a2:a200)=3)*b2:b22) to add another variable =sumproduct((month(a2:a200)=3)*(b2:b22="joe")*c2:c 22) -- Don Guillett Microsoft MVP Excel SalesAid Software "kanstrup" wrote in message ... Hello, I have a list of dollar amounts corresponding with days in the months. I am trying to create a subtotal for each month and not each day of the month. When I do subtotal I get a subtotal for each day of the month. How do I get a total just for the month? Thanks, Chris |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
subtotals
Typo:
=sumproduct((month(a2:a200)=3)*b2:b22) Think it was meant as: =SUMPRODUCT((MONTH(A2:A200)=3)*B2:B200) Ranges have to be identically sized -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
subtotals
Alternative.
Add a column to get the month (=MONTH(A2) for instance), and subtotal by that column. -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "kanstrup" wrote in message ... Hello, I have a list of dollar amounts corresponding with days in the months. I am trying to create a subtotal for each month and not each day of the month. When I do subtotal I get a subtotal for each day of the month. How do I get a total just for the month? Thanks, Chris |
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
subtotals
Thanks for the catch
-- Don Guillett Microsoft MVP Excel SalesAid Software "Max" wrote in message ... Typo: =sumproduct((month(a2:a200)=3)*b2:b22) Think it was meant as: =SUMPRODUCT((MONTH(A2:A200)=3)*B2:B200) Ranges have to be identically sized -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Original subtotals should not be within nested subtotals in excel | Excel Worksheet Functions | |||
Subtotals: Nested subtotals below higher subtotal | Excel Discussion (Misc queries) | |||
How do I copy an outline w/ subtotals & paste just the subtotals | Excel Discussion (Misc queries) | |||
Problem with nested subtotals, placing secondary subtotals BELOW . | Excel Discussion (Misc queries) | |||
why are nested subtotals coming out below outer subtotals? | Excel Worksheet Functions |