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 similar, its just to help view the costs quicker and hopefully elminate errors.
Hi Kimberley,
It could be like
=SUMIF(C1:C30,"X",B1:B30)