R
rerhart
I am having a problem with counting data that is within a certain date.
for example, I have 4 columns. SERVERNAME, LOCATION, TYPE
LEASEENDDATE. I am currently using SUMPRODUCT to count the number o
servers I have for a particular location and type.
A B C D
SERVERNAME LOCATION TYPE LEASEENDDATE
Server1 MN Web 6/30/2004
Server2 CA App 8/15/2004
SUMPRODUCT((B2:B200="MN")*(C2:C200="Web"))
On another sheet, I would like to forecast of how many servers I hav
that are not expired yet for every month of the year and have 1
columns for each month, JAN, FEB, MAR, etc. I am thinking of a formul
like:
For January:
IF((D2200>1/31/2004,SUMPRODUCT((B2:B200="MN")*(C2:C200="Web"))
For February:
IF((D2200>2/29/2004,SUMPRODUCT((B2:B200="MN")*(C2:C200="Web"))
How do I ONLY count the number of 'Web' servers in 'MN' that have no
yet exprited as of (date in column D)?
Thanks
for example, I have 4 columns. SERVERNAME, LOCATION, TYPE
LEASEENDDATE. I am currently using SUMPRODUCT to count the number o
servers I have for a particular location and type.
A B C D
SERVERNAME LOCATION TYPE LEASEENDDATE
Server1 MN Web 6/30/2004
Server2 CA App 8/15/2004
SUMPRODUCT((B2:B200="MN")*(C2:C200="Web"))
On another sheet, I would like to forecast of how many servers I hav
that are not expired yet for every month of the year and have 1
columns for each month, JAN, FEB, MAR, etc. I am thinking of a formul
like:
For January:
IF((D2200>1/31/2004,SUMPRODUCT((B2:B200="MN")*(C2:C200="Web"))
For February:
IF((D2200>2/29/2004,SUMPRODUCT((B2:B200="MN")*(C2:C200="Web"))
How do I ONLY count the number of 'Web' servers in 'MN' that have no
yet exprited as of (date in column D)?
Thanks