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. |
#2
|
|||
|
|||
Hello there,
Try a SumIf function: =SUMIF(B1:B3,"c",A1:A3) Hope this helps Judith -----Original Message----- 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. . |
#3
|
|||
|
|||
=SUMIF(B:B,"c",A:A)
-- HTH RP (remove nothere from the email address if mailing direct) "Anauna" wrote in message ... 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. |
#4
|
|||
|
|||
hi,
=sumif(B1:B3,"c",A1:A3) regards -----Original Message----- 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. . |
Reply |
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 |