Check out some similar questions!

gilda102 · Jul 29, 2008, 02:59 PM

I have two worksheets, the first one is titled 'Daily Log' the other is 'Annual Summary'
Column C on the log worksheet contains G/L codes. Column H contains pledge amounts.
On the summary worksheet I would like to add all of the pledges for each specific G/L code. The formula I am using was taken from another workbook created by someone else. The formula works just fine on that workbook but not on mine. I've already checked that calculation is set to automatic. I've also tried making the formula an array formula.
The formula is: =SUM(IF('Daily Log'!C2:C100="4010",'Daily Log'!H2:H100))

KISS · Jul 29, 2008, 05:31 PM

Is the GL code a string or a number? It looks like this formla expects the gl code to be a string.

Temporarily change any C entry of 4010 to '4010 and see if it works. Note the single quote.

JBeaucaire · Jul 29, 2008, 08:02 PM

Use names to simplify your process.

On Daily Log, highlight cells C2:C100, then NAME the range PLCODES
(Just above column A is a white box you can type that name in directly)
Highlight H2:H100 and NAME the range PLEDGE
On sheet two, your formula is:
{=SUM(IF(PLCode=4010,Pledge))}

This only works when you CTRL-SHIFT-ENTER the formula to properly activate the array.