calculate subtotal

  • Thread starter Thread starter yepiknowiam
  • Start date Start date
Y

yepiknowiam

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.
 
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
 
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?
 
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?
 

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

Totaling Subtotals 2
Excel 2003 running on XP 2
Average of Subtotals in Pivot Table 0
Getting Text data using the Data - Subtotal feature 1
% of subtotal in pivot table 1
Pivot Table Subtotals - Calculated field subtotal incorrect 1
Conditional SUBTOTAL in XL210 Table 7
can i add subtotals to subtotals in a pivot table? 1

Back
Top