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