index row, return dollar amount adding amount together

Hi all,
I am creating a spreadsheet to track expenses. I am assigning a unique number in a column for the different types of expenses. Each expense will have it's own "Total Amount" cell. So in the total cell I am looking to search the column for that particular number, and return the dollar amounts, while adding the amounts together for the total. This is what I have so far. Will anyone help?

Please Login or Register  to view this content.

\
I know this is way off. Will someone help? Thanks!

Just thought I would update this a little more. I have two worksheets. First worksheet is a daily sheet that will track expenses. In Column C, i will assign a number, 1-30, as a number to track the expense. In the same row I will have the dollar amount for that purchase. On the second page I am looking to have a cell that will total all of the purchases under the number 1 or 2, etc. I am having a hard time finishing this. Thanks for your help!

Hi

Can't be sure of your structure from the formula, but have a look at the SUMPRODUCT or the SUMIF functions.

If you can't work something from there, put up a sample file showing your structure, some sample data, and what the result would be for that data.


rylo

What I'm trying to do: There are two worksheets. Daily, and monthly. On the daily page, on the far right side there are catagories denoted by number. On each row, a catagory number will be entered. On the monthly page: I want to "parse" the catagory column and return the total dollars for the month of that "catagory". I hope that makes sense. Here's a file to take a look at. Thanks for any help!!

Hi,

for cat 1, in monthly expenditure E11

Please Login or Register  to view this content.

=SUMIF('Daily Expenditure'!G7:G17,1,'Daily Expenditure'!K7:K17)

Please Login or Register  to view this content.

use the same formula in the other cells, replacing the number 1 wth 2,3,4 etc

Ed

Thanks for your help. The formula does what I am looking to do. I will look into these functions more. Thanks again!