Using Conditions to Add Values

[EclipticalD]

Hi there!


This is my first time looking in a forum for office help, never quite passed from "basics" at school, but I'm trying to do a worksheet that'll help me control better my finances...in a particular point in my work I stumbled with a small problem I wish someone could help me with.

I have categorized my expenses and made them a list in a sheet showing a "total amount" column, in a separate sheet I control the monthly actual movement and enter my expenses, select the category from a list and add the value.

What I want to do is to make my first spreadsheet to add values from the second sheet based on the category selected. For instance, If I have 5 movements some categorized as "transportation" and others as "Groceries" then in the first spreadsheet it would show the total amount spent on "transportation" and "Groceries"

I hope I was clear with my questioning but still any help or guidence in this matter would be greatly appreciated. ^_^

[ConneXionLost]

It seems that what you're describing could be accomplished with the SUMIF or SUMIFS functions. Have a look in Excel Help for their descriptions.

If you're still stuck, then consider posting a "sample" workbook with what you're trying to do.

Cheers,