Thanksssssssssss aloooooooooooooot.......................great my problem is
solved

I need this formula =SUMPRODUCT(--(A1:A10="Pen"),--(B1:B10="Yes"),--(c1:
c20=20))

thanks......:)

Dave Peterson wrote:
Do you mean sum column C for Pen and Yes?
=SUMPRODUCT(--(A1:A10="Pen"),--(B1:B10="Yes"),c1:c10)

If you really meant that you wanted to count Pen/Yes/20 (unlikely, huh?):
=SUMPRODUCT(--(A1:A10="Pen"),--(B1:B10="Yes"),--(c1:c20=20))

Thanks alot this funtion works.... now i have a problem that i have more than
2 columns to compare & take SUM of values. for example
[quoted text clipped - 29 lines]
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200705/1


--
Message posted via http://www.officekb.com