Add up prices in a column if checkbox is selected.

AuroraRon · 08/16/17

I have a list of parts and prices. I would like to have a total cost add up for the rows selected by a checkmark. Basically it is a parts list and I am trying to add up for a quick quote the items selected.

Is there a way to do this?

Mehmet Zengin · 08/16/17

Hi,

Give this a try

=SUMIF(Formula1:Formula3, @cell = 1, Price1:Price3)

Mike Wilday · 08/16/17

Aurora, if you use that formula, you would need to label your check mark column as "Formula" and your price column as "Price". And make sure that you update the row numbers to represent your parts list numbers.

AuroraRon · 08/16/17

=SUMIF([Check Mark]4:[Check Mark]85,1),[COST CDN]4:[COST CDN]85

Is what I'm trying. The place where the formula is says #unparseable

I wanted to add up numbers in COST CDN from row 4-85 if the check mark is selected on that row. I am trying SUMIF because I think the example shown in another answer was adding up the check marks not the values in COST CDN

Thanks again for the help.

AuroraRon · 08/16/17

I figured it out, brackets in the wrong place. This works

=SUMIF([Check Mark]4:[Check Mark]85, 1, [COST CDN]4:[COST CDN]85)

Thanks for the help!

Mike Wilday · 08/17/17

Yep. Was just going to mention that! Good catch.

Welcome to the Smartsheet Forum Archives

Add up prices in a column if checkbox is selected.

Comments

Categories