Formula is not calculating
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))