Can anyone help with this formula?
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
|