Quote:
Originally Posted by Claus Busch
Hi Dawn,
Am Wed, 10 Jun 2015 16:08:06 +0100 schrieb dawn48313:
=SUMPRODUCT(InstrumentLog!F2:F47,"In
Service",InstrumentLog!K2:K47,"<"&TODAY())
=SUMPRODUCT(InstrumentLog!F2:F47,"In
Service",InstrumentLog!K2:K47,""&TODAY(),Instrume ntLog!K2:K47,"<="&TODAY()+30)
try:
=SUMPRODUCT(--(InstrumentLog!F2:F47="In Service"),--(InstrumentLog!K2:K47<TODAY()))
and
=SUMPRODUCT(--(InstrumentLog!F2:F47="In Service"),--(InstrumentLog!K2:K47TODAY()),--(InstrumentLog!K2:K47<=TODAY()+30))
Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional
|
Aww crap, one more thing please. Sorry. I just noticed that it says 31-60 days, and 61-90 days. How do I calculate it so that it shows that 6 need to be calibrated in 32 days but not show up in the 31 to 60 days?