Hi there

I have inherited a huge spreadsheet which runs a bunch of macros, is
protected (until I select unprotect), has multiple frame freezes,etc.

I have to tally up all the Consumables for a particular project based on a
certain grant code. I have tried using SUMIF(F21:F102,"14",AK21:AK102) but it
keeps returning 0 which is certainly not the case. (F$ is the column for
grant code and AK$ stores the dollar value of consumable.)

Am I using the wrong formula, or could it be as simple as a format error,
or....

Any suggestions?

Thanks