Calculate Invoices Based on Dates

  • Thread starter Thread starter carltonb
  • Start date Start date
C

carltonb

If I input a years worth of invoice totals I would like to c alculate the
amount spent for each month and have that total displayed.

So I would like to find all the dollars spent in Januray, February, etc.

Thanks for the help
carltonb
 
You can do this with the Subtotals function. In a column next to the
amounts, enter the month to which each amount pertains, and head the column
as "Month." You can list the months as 01, 02, etc. or with their names.
Sort the list so all of January's are together, all of February's, etc. Then
use Data-Subtotals and tell it "At each change in" Month. You will then see
a subtotal for each month, and a grand total if you want one.
 
Assuming the following format:

A B
1 January 100.00
2 February 200.00
3 January 300.00
....

Use the following:

=SUMIF(A1:A100, "January", B1:B100)

Change your ranges above to reflect yours, naturally.

/i.
 
Back
Top