Forum Discussion
Kimberley Lomas
Jun 11, 2018Copper Contributor
Formula for marked cells
Hi, I want to create a formula for the below image where if the columns are marked with and X then the test price is added into the total cell at the bottom. Is this possible? Or something simila...
SergeiBaklan
Jun 11, 2018Diamond Contributor
Hi Kimberley,
It could be like
=SUMIF(C1:C30,"X",B1:B30)