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 4479 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.




1 reply

rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 768
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
0