Sum certain cells in a column if corresponding cells of another [Closed]

Report
Posts
1
Registration date
Monday January 14, 2013
Status
Member
Last seen
January 14, 2013
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
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.




1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
767
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

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!