=SUMPRODUCT(--(A1:A10=D2),--(B1:B10=E2))


where you would put Pen in D2 and Yes in E2
or you can hard code it but then you need to change the formula when you
change criteria

=SUMPRODUCT(--(A1:A10="Pen"),--(B1:B10="Yes"))


--
Regards,

Peo Sjoblom



"adeel via OfficeKB.com" <u32736@uwe wrote in message
news:7244ab3129bc1@uwe...
Hi. I have set of Text Values in 2 Columns (eg A1 & B1), in A1 the value
are
like (eg Pen, Pencil) & in B1 values are 'Yes' (in some cell) 'No' (in
some
cell). I want to take Sum of 'Pen' which have 'Yes' in Coloumn B1, & Sum
of
'Pencil' which have 'Yes' in Column B1, and same with 'No'...hope some one
understade this...and help me....thanks...
A1 B1

Pen Yes
Pencil Yes
Pen No
Pencil No
(take SUM of Pencils with Yes in B1)

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200705/1