View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ian P
 
Posts: n/a
Default how to use a variable for the criteria in a sumif function?

I didn't think it was possible to define a variable in "just" Excel. I
thought this had to be do in VB. If I've got it wrong then how do you define
variables in Excel?

Thanks

Ian

"Elkar" wrote:

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