Trying to add data from one column based upon categorization in another column

[rainymagoo]

I'm building a home finances tracker in Excel, and so far all is working for me, except this. Entries in Column C have been given a rating of 1-4 in Column E. On another worksheet, I would like to add all 1's, 2's and 3's to help track where money goes. I can't seem to get the formula right to take the $'s in C and add them, but only if they meet certain criteria (their Column E "value"). Please help!

[sglife]

A sumif or sumproduct function can help you.
You can either try to settle the problem by using the 2 formulas or attach your file here

[Cheeky Charlie]

=sumproduct(c1:c10,--(e1:e10<4))

HTH

[rainymagoo]

Tried sumproduct and sumif, all I get is "0". I don't really want to upload this spreadsheet, as it's personal finances. I'm going to create an example and upload that to link from sglife. If I never am able to disseminate this data, I probably won't cry, but it sure would be nice if I could do this. Thank you for your help, Cheeky Charlie. I'll try to have that uploaded tonight, sglife.

[Hughie]

If I understand, your sheet 1 Column C contains dollar values and Column E categories of 1 thru 4. Try the following formula on sheet 2 in whatever cell you wish the result to be in - =SUMIF(Sheet1!E2:E7,"1",Sheet1!C2:C7)

[Cheeky Charlie]

My first formula was rubbish actually, this makes much more sense:

=SUMIF(E:E,"<4",C:C)

Tested it and works fine for me.
At a guess your problem is that your 1-4 in E are strings not numbers (if you are using a vlookup or something be sure not to put "numbers" in it:
i.e. =if(true,1,0) not =if(true,"1","0")

HTH