Home |
Search |
Today's Posts |
#1
|
|||
|
|||
sum cells based on another cell value
Hello,
I have column A listing whole numbers. Column B lists categories a,b, or c. I would like to sum the values in column A only if the corresponding cell in Column B contains the letter c. ie. 10 c 20 b 15 c sum = 25 -- Thank-you and all suggestions are appreciated. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is it possible to change colors of cells based on value in cell (. | Excel Worksheet Functions | |||
I want to format a cell based on an adjacent cells value | Excel Discussion (Misc queries) | |||
GET.CELL | Excel Worksheet Functions | |||
Modify Row & Cell Contents based upon Cells Values | Excel Worksheet Functions | |||
Modify Row & Cell Contents based upon Cells Values | Excel Worksheet Functions |