Counting totals with checkbox rows

Lee Ackerman

Hi there,

I am trying to set up a formula where it will add up all of the "buying price" column where "sold" is checked.

I want to see the total value of all sold units, based on the check box approach.

See attached image.

Can any body advise how to achieve this? I've been messing around now for a long time, and I cannot fathom it!

Thanks,

Lee.

Andrée Starå

Hi@Lee Ackerman

Try something like this.

=SUMIF(Sold:Sold; 1; [Buying Price]:[Buying Price])

The same version but with the below changes for convenience.

=SUMIF(Sold:Sold, 1, [Buying Price]:[Buying Price])

Depending on your country/region, you'll need to exchange the comma to a period and the semi-colon to a comma.

Did that work?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå| Workflow Consultant / CEO @WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community bymarking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Lee Ackerman

Hi @Lee Ackerman<\/a> <\/p>

Try something like this.<\/p>

=SUMIF(Sold:Sold; 1; [Buying Price]:[Buying Price])<\/p>

The same version but with the below changes for convenience.<\/p>

=SUMIF(Sold:Sold, 1, [Buying Price]:[Buying Price])<\/p>

Depending on your country\/region, you'll need to exchange the comma to a period and the semi-colon to a comma.<\/p>

Did that work? <\/p>

I hope that helps!<\/p>

Be safe and have a fantastic week!<\/p>

Best,<\/p>

Andrée Starå<\/strong><\/a> | Workflow Consultant \/ CEO @ WORK BOLD<\/strong><\/a><\/p>

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by <\/em>marking it as the accepted answer\/helpful<\/em><\/strong>. It will make it easier for others to find a solution or help to answer!<\/em><\/p>","bodyRaw":"[{\"insert\":\"Hi \"},{\"insert\":{\"mention\":{\"name\":\"Lee Ackerman\",\"userID\":127510}}},{\"insert\":\" \\nTry something like this.\\n=SUMIF(Sold:Sold; 1; [Buying Price]:[Buying Price])\\nThe same version but with the below changes for convenience.\\n=SUMIF(Sold:Sold, 1, [Buying Price]:[Buying Price])\\nDepending on your country\\\/region, you'll need to exchange the comma to a period and the semi-colon to a comma.\\nDid that work? \\nI hope that helps!\\nBe safe and have a fantastic week!\\nBest,\\n\"},{\"attributes\":{\"bold\":true,\"link\":\"mailto:andree@workbold.com\"},\"insert\":\"Andrée Starå\"},{\"insert\":\" | Workflow Consultant \\\/ CEO @ \"},{\"attributes\":{\"bold\":true,\"link\":\"https:\\\/\\\/workbold.com\\\/\"},\"insert\":\"WORK BOLD\"},{\"insert\":\"\\n✅\"},{\"attributes\":{\"italic\":true},\"insert\":\"Did my post(s) help or answer your question or solve your problem? Please help the Community by \"},{\"attributes\":{\"italic\":true,\"bold\":true},\"insert\":\"marking it as the accepted answer\\\/helpful\"},{\"attributes\":{\"italic\":true},\"insert\":\". It will make it easier for others to find a solution or help to answer!\"},{\"insert\":\"\\n\"}]","format":"rich","dateInserted":"2020-10-13T13:54:59+00:00","insertUser":{"userID":8888,"name":"Andrée Starå","title":"Smartsheet Expert Consultant & Partner | Workflow Consultant \/ CEO @ WORK BOLD","url":"https:\/\/community.smartsheet.com\/profile\/Andr%C3%A9e%20Star%C3%A5","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/0PAU3GBYQLBT\/nXWM7QXGD6464.jpg","dateLastActive":"2023-08-26T17:06:33+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"displayOptions":{"showUserLabel":false,"showCompactUserInfo":true,"showDiscussionLink":false,"showPostLink":false,"showCategoryLink":false,"renderFullContent":false,"expandByDefault":false},"url":"https:\/\/community.smartsheet.com\/discussion\/comment\/265813#Comment_265813","embedType":"quote"}"> https://community.smartsheet.com/discussion/comment/265813#Comment_265813

Hi@Andrée Starå,

Thanks for your response. I forgot to mention that I am trying to run this formula in another sheet, like a master sheet I am using as a "dashboard". I have tried your formula referencing a different sheet, but it doesn't compute, "unparseable".

What would be the right way to reference this to another sheet?

Thanks,

Lee.

Andrée Starå

@Lee Ackerman

Happy to help!

Try something like this.(You'll need to type it in and create the cross-sheet references to the other sheet)

Make sense?

=SUMIF({Sold}; 1; {Price})

Lee Ackerman

@Andrée Starå

This is what I am now trying with no result...

=SUMIF({C - February Range 7}, ({Sold}, 1, {Price}))

Can you see where I might be going wrong?

Again, thank you for your help!

Lee.

Lee Ackerman

I have also tried this alternative...

=SUMIF({C - February Range 3}; 1; {C - February Range 5})

Again, no joy, I am definitely doing something wrong here.

Andrée Starå

@Lee Ackerman

Yes, you have a parenthesis in the wrong place (before the sold).

Try this.

=SUMIF({C - February Range 7}, {Sold}, 1, {Price})

Did that work?

Lee Ackerman

@Andrée Starå

This does something different as I'm getting a different error, it's now saying "incorrect argument" instead of "unparsable".

Thanks,

Lee.

Andrée Starå

@Lee Ackerman

I'd be happy to take a quick look.

Can you maybe share the sheet(s)/copies of the sheet(s)? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too,[email protected])