Need help with excel function
 

I am starting a spreadsheet to keep track of income and expenses and
as of now i have Columns: Date, Item, Type, Payee, Amount, and
Balance.

I want to try and keep track of how much i spend on each "type" so for
example the Type column is in column C and the amount column is in
column E, what I want to do is have a seperate chart and basically
have a number pop out sorting the amounts of each type.

So lets say the type I want is "Income" what formula would I put if i
want to add all the amounts in column E that have the word "income" in
the same row in column C, if that makes sense

Thanks

Need help with excel function
 

Look in the help index for SUMIF

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

wrote in message
...
I am starting a spreadsheet to keep track of income and expenses and
as of now i have Columns: Date, Item, Type, Payee, Amount, and
Balance.

I want to try and keep track of how much i spend on each "type" so for
example the Type column is in column C and the amount column is in
column E, what I want to do is have a seperate chart and basically
have a number pop out sorting the amounts of each type.

So lets say the type I want is "Income" what formula would I put if i
want to add all the amounts in column E that have the word "income" in
the same row in column C, if that makes sense

Thanks