Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
calculate subtotal
Wondering if someone can help me with a formula. I would like to calculate
the subtotal for a given month, where the month is in 8/12/2008 format. After calculating the subtotal, would like the total to be placed into a specific column that I specify. Also would like the totals to be updated if new info is inputed. Can someone help me out where to start and what I need to do? Thanks. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
calculate subtotal
Assuming your dates are in column A and the figures you want to add are in
column B. Put this formula in the cell you want the sum in. =SUMPRODUCT((MONTH(A2:A100)=8)*(B5:B100)) "=8" represents August. change that for different months. Hope that helps "yepiknowiam" wrote in message ... Wondering if someone can help me with a formula. I would like to calculate the subtotal for a given month, where the month is in 8/12/2008 format. After calculating the subtotal, would like the total to be placed into a specific column that I specify. Also would like the totals to be updated if new info is inputed. Can someone help me out where to start and what I need to do? Thanks. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
calculate subtotal
For example, the date field is in section D, The numbers are in section G and
need to add the totals and place the value in section K4. What would I need to do for this example? "Gaurav" wrote: Assuming your dates are in column A and the figures you want to add are in column B. Put this formula in the cell you want the sum in. =SUMPRODUCT((MONTH(A2:A100)=8)*(B5:B100)) "=8" represents August. change that for different months. Hope that helps "yepiknowiam" wrote in message ... Wondering if someone can help me with a formula. I would like to calculate the subtotal for a given month, where the month is in 8/12/2008 format. After calculating the subtotal, would like the total to be placed into a specific column that I specify. Also would like the totals to be updated if new info is inputed. Can someone help me out where to start and what I need to do? Thanks. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
calculate subtotal
If the date range is from D2-D57, would you need to put in exactly
((MONTH(D2:D57)=8)* or is there a wild card you can use for all of one month? "Gaurav" wrote: Assuming your dates are in column A and the figures you want to add are in column B. Put this formula in the cell you want the sum in. =SUMPRODUCT((MONTH(A2:A100)=8)*(B5:B100)) "=8" represents August. change that for different months. Hope that helps "yepiknowiam" wrote in message ... Wondering if someone can help me with a formula. I would like to calculate the subtotal for a given month, where the month is in 8/12/2008 format. After calculating the subtotal, would like the total to be placed into a specific column that I specify. Also would like the totals to be updated if new info is inputed. Can someone help me out where to start and what I need to do? Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need formula to calculate subtotal before sales tax | Excel Worksheet Functions | |||
Subtotal vs calculate vs sumif ??? | Excel Worksheet Functions | |||
pasting to subtotal lines without replacing hidden -non-subtotal l | Excel Discussion (Misc queries) | |||
How to calculate shipping costs based on subtotal | Excel Worksheet Functions | |||
How to calculate subtotal if a row is hidden | Excel Worksheet Functions |