How do I sum multiple columns counting including blanks and dates
 

I have two columns of which I want to use as criteria to add contents of a
third column. The columns may or may not be blank and one of the columns if
complete should only be counted if date less than 7/1/2005 for example. I
would like to sum and also count this data.

How do I sum multiple columns counting including blanks and dates
 

=SUMPRODUCT(--(A2:A20<=--"2005-07-01"),--(B2:B20="criteria"),C2:C20)

should do it, replace criteria with your secondary test value

--

HTH

RP
(remove nothere from the email address if mailing direct)


"BK99" wrote in message
...
I have two columns of which I want to use as criteria to add contents of
a
third column. The columns may or may not be blank and one of the columns
if
complete should only be counted if date less than 7/1/2005 for example. I
would like to sum and also count this data.