Previous Topic Next Topic

Sum certain cells in a column if corresponding cells of another

Closed
taiawelty Posts 1 Registration date Monday January 14, 2013 Status Member Last seen January 14, 2013 - Jan 14, 2013 at 07:28 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jan 14, 2013 at 08:11 PM
Hello,

I want to sum certain cells in a column if corresponding cells in another column contain a certain letter.

I have amounts in cells G2:G12. Cells L2:L212 might contain an X. I want the sum of only the cells in column G that have an X in the corresponding cell of column L.

Thank you in advance for any help you can give me.




Related:

1 response

Answer 1 / 1
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Jan 14, 2013 at 08:11 PM
when "Contains X" is said, does it mean that one of the letters would be X or would there be only X in the cell. If later is the case, then you want to look into SUMIF function

Similar discussions

If a cell contains any text then add a value
cbrizz -
Pharmanumbers -

20 responses
How to use conditional format based on text?
Leanne99 -
Mooseman -

26 responses
Highlight cell if another cell contains specific text
Abbi -
vcoolio -

1 response
help me to add particular cells
mathewmunna -
mathew munna -

2 responses