Tracking Expenses

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Mickey Mouse - 20 Dec 2006 00:47 GMT

I have a list of expenses, some of these expenses are electricity bills.
I have a column A 'Date', column B "Description", next column C is 'Amount'
and next D column is 'Paid'.
There are several entries for electricity mixed in with other entries such
as registration, petrol, insurance etc

I'd like excel (2002) to search column B and calculate all the entries for
electricity only so I can display the total. Is a macro the only way to
achieve this? I'm not familiar with macro's YET.

Mickey

Reply to this Message

Roger Govier - 20 Dec 2006 01:12 GMT

Hi

One way
=SUMIF($B:$B,"Electricity",$C:$C)

Instead of putting the word Electricity in the formula, you could use a
cell reference where you had entered the word Electricity, e.g in cell
F1
then enter in cell F2
=SUMIF(B:B,F1,C:C)

Now, if you enter other expense types in G1, H1 etc. and drag the
formula across you will get the totals for other categories.

Signature

Regards

Roger Govier

>I have a list of expenses, some of these expenses are electricity
>bills.
[quoted text clipped - 8 lines]
>
> Mickey

Reply to this Message

Rate this thread: