Forum Discussion
shanioreo
May 02, 2025Copper Contributor
Giving a range of information in cells number values
I am making a schedule for my team that requires multiple parts. First I would like to give the shifts a value of 1 and the OFF days a value of 0. Then I would need a formula that when those are inpu...
Kidd_Ip
May 03, 2025MVP
You may consider conditional formatting and SUMIF:
Example:
=SUMIF(B2:H2, 1)