=SUMPRODUCT(--(A2:A20="me"),C2:C20)-SUMPRODUCT((A2:A20="me")*(B2:B20={"green
","orange","bean","apple","bananas","corn"})*C2:C2 0)
--
HTH
RP
(remove nothere from the email address if mailing direct)
"Jan" wrote in message
...
I did post this earler, but don't see it listed. Sorry, if it is a
duplicate
post.
I'm using Excel 2003.
I need a formula to do the following:
If column A = "me" and
column B < "green", "orange", "bean", "apple", "bananas" or corn" then
Sum column C.
TIA
|