How to Sum Amounts According to Category

[phillipsry]

In Excel 2007 am preparing an expense report and need to know how to sum up all dollar amounts according to their defined category. Here is an example of the layout of my spreadsheet...

Date Description Amount Category
1/1/11 Joe's Fuel Depot $50.00 Fuel
1/5/11 Counter Credit $100.00 Deposit
1/8/11 Max Office Supplies $34.00 Supplies

Any help is greatly appreciated!!

 

[Smitty]

Welcome to the Board!

You can use SUMIF.

E.G. =SUMIF(D2:D100,"Fuel",C2:C100)

HTH,

 

[phillipsry]

I used this formula and it came up with the following error...

<table border="0" cellpadding="0" cellspacing="0" width="282"><tr height="20"><td style="height: 15pt; width: 212pt;" align="center" height="20" width="282">¿NOMBRE?
</td> </tr></table>

 

[phillipsry]

I used this formula and it came up with the following error... "#¿NOMBRE?"

I am using a spanish version, so obviously this would be translated as "#¿NAME?

I used your formula and changed the variables so that it would calculate the amounts according to my spreadsheet's parameters but with no luck

ALSO, once I have this information compiled, is there a way to create an expense report in the form of a labeled pie chart?

Thank you so much for you assistance!!! It is very appreciated!

 

[Smitty]

Unfortunately, I don't know the Spanish formula translations, but I did find a link:

http://www.piuha.fi/excel-function-name-translation/index.php?page=english-spanish.html

You're looking for SUMAR.SI

 

[phillipsry]

That did it Smitty! Thanks!