Hi Greg,

Try this: =SUMIF(A1:A100,"A*",B1:B100)

Regards,
KL


"GregR" wrote in message
ups.com...
I have a table where I want to sum all the values in "F", if the cells
in "A" begin with "05". "A" actually contains account numbers, which
are text, that the first two numbers are the fiscal year. I can't quite
get my head around a sumif or other formula. TIA

Greg