Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
HOW TO TAKE SUM OF TEXT VALUES
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I sum values in a row if the value in a row above = text | Excel Worksheet Functions | |||
TEXT VALUES !!! | Excel Discussion (Misc queries) | |||
Top 10 Text Values | Excel Worksheet Functions | |||
Text values to numeric values | Excel Discussion (Misc queries) | |||
Text Values | Excel Discussion (Misc queries) |