Sumif problem
=SUMIF(A:A,"05*",F:F)
This won't work if the account number is an actual number (rather than
alphnumeric) stored as
511111 for example and formatted to display a leading zero (0511111).
Likely this is not the case.
--
Regards,
Tom Ogilvy
"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
|