0

I am making a checkbox inventory counter that auto increments

I have tried many if then statements to increase a cell value when a box or multiple boxes is check. The best I could do was display a number but it disappears once the checkboxes are unchecked. So I would like and cell to auto increase by 1 after the last or all boxes are checked

player0
  • 124,011
  • 12
  • 67
  • 124
boyd maher
  • 1
  • Welcome to [Stack Overflow](https://stackoverflow.com/tour). Consider sharing a publicly editable sample spreadsheet. There is a [blank sheet maker](https://docs.google.com/forms/d/e/1FAIpQLSeprZS3Al0n7JiVQIEiCi_Ad9FRXbpgB7x1-Wq6iAfdmVbWiA/viewform) that lets you share safely. – doubleunary Jan 13 '23 at 09:07
  • Something like `=COUNTIF(A1:A10,TRUE)` should do that. See more at: [COUNTIF](https://support.google.com/docs/answer/3093480) – idfurw Jan 13 '23 at 09:25
  • A script will be required to increment a number and keep it that way even when those checkboxes are unticked. The requirements are too vague to suggest a concrete solution. – doubleunary Jan 13 '23 at 09:40
  • "disappears once the checkboxes are unchecked" - what you need is a script – player0 Jan 13 '23 at 09:40

0 Answers0