Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have a workbook i use to make reports every month.
I have lot of formulas that counts how many of the diferent values it is in a given time interval. Like this:=COUNTIFS(Saker!$C$36:$C$133;$C14;Saker!$F$36 :$F$133;"1/1-2008") To reduce work i wish to replace the date in the logical check with a variable/name. I have been able to make a name/variable and replace the full logical check by setting Name "START" to "1/1-2009" or similar, but i would like to only use the variable for the date as otherwise i have to make one for each logical test. (one for less than start, one for afther start, one for less or like start and so on). |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Logical formulas | New Users to Excel | |||
Logical Formulas | Excel Worksheet Functions | |||
If, Logical Values. | Excel Discussion (Misc queries) | |||
logical formulas in excel | Excel Discussion (Misc queries) | |||
SUM for logical values | Excel Discussion (Misc queries) |