How to setup formula for Countif and then divide

%3CLINGO-SUB%20id%3D%22lingo-sub-2342920%22%20slang%3D%22en-US%22%3EHow%20to%20setup%20formula%20for%20Countif%20and%20then%20divide%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2342920%22%20slang%3D%22en-US%22%3E%3CP%3EI%20used%20countif%20formula%26nbsp%3B%3DCOUNTIF('Goal%20Tracker'!H12%3AJ28%2C%22g%22)%20and%20need%20to%20divide%20the%20answer%20by%208.%26nbsp%3B%20How%20do%20I%20write%20the%20formula%20to%20include%20the%20divide%20by%208%20part%3F%26nbsp%3B%20Thanks.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2342920%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

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
Try: =COUNTIF('Goal Tracker'!H12:J28,"g")/8