how to use a variable for the criteria in a sumif function?
Remove the quotes.
=sumif(A1:A4,currentjobno,B1:B4)
HTH,
Elkar
"Dick B." wrote:
I am trying to use a named variable for the criteria in a sumif function.
=sumif(A1:A4,"currentjobno",B1:B4)
currentjobno has a value of 38006
|