This looks like a job for an array function. Type the expression below in
the cell where you want the total number of rows with "Pen" and "Yes" and
then hit CTL-SHIFT-ENTER (rather than just ENTER). Squiggly brackets ("{}")
should appear around the expression in the edit window.

=SUM((A1:A4="Pen")*(B1:B4="Yes")*1)

Adjust the range in this expression as needed. Create similar expressions
for the other combinations by substituting for "Pen" and/or "Yes".

Will

"adeel via OfficeKB.com" wrote:

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