Excel formula for calculating total payments made using Amex card

[balajivenkateshan]

I need a formula for calculating the total payments made using the Amex card - catch is to get it for the billing cycle - 24 of a month to 23 of the next month....in the my case ( from Aug 24 - 23 Sep and the next billing cycle from 24 Sept to 23 Oct) below is the table :-


Month Date Expense Description Type Payment Mode Amount
Sep'12 19 Santana Beach - Payments Amex 875
Sep'12 22 Green Trends Payments Amex 674
Sep'12 23 Heritage Payments Amex 499
Sep'12 24 Bank Charges Payments Amex 641.76
Sep'12 24 Bank Charges Payments Amex -173.96
Sep'12 24 IRCTC - Cancellation Received Amex 1876
Sep'12 24 IRCTC - Cancellation Received Amex 1560


Thanks

[EINSTEIN_007]

There are different ways you could do it, but the function you would be most likely to use is the Sum function. Incase you only have individual incomes and just want to total them, then in the cell where you want the total type in:

=Sum(

and then select the cells that you want added using the mouse and then press enter.

If your figures were in cells A1, A2, A3, A4, A5, A6 and A7 and your formula was in A8, then the formula would be:

=Sum(A1:A7)

That is telling Excel to add all the values in the cells from A1 to A7.