Is there a formula for this?

[Lee]

I want cell A6 to show the sum of cells A1,A2,A3,A4, and A5 however of those
5 cells I only want it to add the cells that have an "X" in the corresponding
B cell beside it. Is there a way to do this?

 

[Ron de Bruin]

Hi Lee

=SUMIF(B1:B5,"x",A1:A5)

 

[Steve Yandl]

=SUMIF(B1:B5,"=x",A1:A5)


Steve