Home |
Search |
Today's Posts |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I use the sumif if I have multiple criteria (i.e. greater . | Excel Worksheet Functions | |||
Custom functions calculating time arguments Help Desperate | Excel Worksheet Functions | |||
SUMIF function using Criteria on different worksheet | Excel Discussion (Misc queries) | |||
Using ADD function within DCOUNT criteria | Excel Discussion (Misc queries) | |||
Can I use a cell reference in the criteria for the sumif function. | Excel Worksheet Functions |