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