Forum Discussion

TM007235's avatar
TM007235
Copper Contributor
May 11, 2021

How to setup formula for Countif and then divide

I used countif formula =COUNTIF('Goal Tracker'!H12:J28,"g") and need to divide the answer by 8.  How do I write the formula to include the divide by 8 part?  Thanks.

1 Reply

  • JMB17's avatar
    JMB17
    Bronze Contributor
    Try: =COUNTIF('Goal Tracker'!H12:J28,"g")/8

Resources