Thread
:
how to use a variable for the criteria in a sumif function?
View Single Post
#
1
Posted to microsoft.public.excel.worksheet.functions
Dick B.
Posts: n/a
how to use a variable for the criteria in a sumif function?
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
Reply With Quote