L
Lorentzt
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).
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).