I would like to create a formula that takes... but I dont seem to understand by COUNTIF isn't working...
What I want is to enter..
1) A value at (C2)
2) (a formula that) Divides that Value by how many clicked checkboxes in a specified range...
I'm horrible at this... I tried...
=C2 / (SUM(COUNTIF (E2, G2, I2, K2, True))
=C2 / SUMIF (E2, G2, I2, K2, True)
Those functions need an array/range as the first parameter. You can turn your four cell references into an array using the { } brackets
=C2/COUNTIF({E2,G2,I2,K2},TRUE)
Those functions need an array/range as the first parameter. You can turn your four cell references into an array using the { } brackets
=C2/COUNTIF({E2,G2,I2,K2},TRUE)
In cell F2 it would be =IF(E2,$C2/COUNTIF({$E2,$G2,$I2,$K2},TRUE),0)
Put it in that cell. Make sure it has the $ signs where indicated.
Fill down to complete that column. The cell reference row numbers will adjust for the correct row.
Copy paste that column of formulas to the other columns that need the formula. The E2 in the formula will adjust so it refers to the correct checkbox.
Thank you! That worked. I have one more request if you'd be so kind! The last part of this equation is...
1) If a box is not checked (false), then the formula will show "0" in the corresponding box. Based off the screenshot. Since "Amber" is not checked, she would show a "0". If you ever make it up to Alaska buy you a beer!
Numbers Formula Issue
