SUMS and IF Formulas
Hi
I need a formula that sums up the value of children that are checked off in my sheet. I hope i am making sense.
So i have a sheet 4 columns, qty x cost. this produces a sum then a column that has check boxes, i only want the formula to sum up those those cells that have been checked off.
I hope I am explaining it correctly.
Thank you in advance
Best Answer
-
=if(checkbox@row=1,qty@row*cost@row,"")
You'll need to use the column names in place of what I wrote. After it is working how you want you can right-click on the cell and convert it to a column formula so it works on the whole column.
Answers
-
=if(checkbox@row=1,qty@row*cost@row,"")
You'll need to use the column names in place of what I wrote. After it is working how you want you can right-click on the cell and convert it to a column formula so it works on the whole column.
-
Hi Devin, thank you
so i tried your formula but it's not working. Here is what I typed out
Help me, please. and thank you
=if(Scope@6=1,Qty@6*cost@6,"")
-
=IF(Scope@row = 1, Qty@row * Cost@row)
-
got it! thank you
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!