How do I sum multiple columns counting including blanks and dates

[BK99]

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.

[Bob Phillips]

=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" <BK99@discussions.microsoft.com> wrote in message
news:2F0DA4C1-D57D-45E2-93E2-707570A14678@microsoft.com...
> 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.
>
>