How can you add numbers from B where B = Yes.

Assuming you meant C

=SUMPRODUCT(--(A1:A1000="Monday"),--(B1:B1000="Yes"),C1:C1000)

--

HTH

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


"CheriT63" wrote in message
...
How do I add the numbers of cells in column B only if they meet the
criteria
of "Monday" from column A and "Yes" from column B?

Thanks for any help!