Sum one range based on another

[tc88]

I tried attacking this as a SUMIF, but no dice.

I am working on budgeting for 2012 at work based on general ledger accounts and departments. Some of this information is going to be updated later and needs to be ommitted from the SUM, the numbers are just a place holder. In the SUM, I only want to include GL Accounts higher than 502000 since GL Accounts below that number will be updated later.

There are 50+ departments I have to do this for, this is just one for an example. I am also open to suggestions on how to accomplish this faster than going through and updating the total rows for each department with the appropriate ranges.

Thanks in advance for any help!

EDIT: As you can see, the SUMIF I tried doesn't give me the right answer. The right answer should be 8,824.

Excel Workbook
	C	J
3	GL Account	Jan 12 Budget
4	5000	21,378
5	5011	23,260
6	5012	1,715
7	501010	5,562
8	501020	67,468
9	501030	4,794
10	503220	500
11	503630	279
12	503650	824
13	503680	247
14	504530	217
15	504532	252
16	504610	4,544
17	504640	669
18	508720	168
19	508860	992
20	510148	134
21		0
Cost Center Budgeting-2011 YTD

Excel 2010

Cell Formulas
Range	Formula
J4	=$F4
J5	=$F5
J6	=$F6
J7	=$F7
J8	=$F8
J9	=$F9
J10	=$F10
J11	=$F11
J12	=$F12
J13	=$F13
J14	=$F14
J15	=$F15
J16	=$F16
J17	=$F17
J18	=$F18
J19	=$F19
J20	=$F20
J21	=SUMIF(C4:C20,C4:C20>"50200",J4:J20)

 

[pagrender]

Does this work for you?
=SUMIF(B4:B20,">502000",J4:J20)

 

[tc88]

Does this work for you?
=SUMIF(B4:B20,">502000",J4:J20)

Yes it does, I just had to change B4:B20 to C4:C20. Thanks for the quick response!

 

[pagrender]

Oops. Sorry about the error in the cell references. Nice catch.

Thanks for the feedback!