Thanks this still only produces a 0 as the return data which is invalid.
Quote:
Originally Posted by Claus Busch
Hi,
Am Wed, 16 Apr 2014 01:48:39 +0100 schrieb cdmartin:
Return the sum of the count from Column G that contains a date of
1/1/2050, and a count for Column H that is equal to today().
try:
=SUMPRODUCT(--(G1:G1000=DATE(2050,1,1)),--(H1:H1000=TODAY()))
Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional
|