How to use names for values in logical formulas.
 

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

How to use names for values in logical formulas.
 

Make it a cell

from
this:=COUNTIFS(Saker!$C$36:$C$133;$C14;Saker!$F$36 :$F$133;"1/1-2008") To

to
this:=COUNTIFS(Saker!$C$36:$C$133;$C14;Saker!$F$36 :$F$133;"" & A1) To


"Lorentzt" wrote:

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