Question

On the food inventory worksheet, enter a function in cell G1 that counts the number of Food Items. What formula would i use!? This is for MOS Excel on Gmwtrix. thnxxx

Answer 1

COUNT function

COUNT function determines how many cells in a range contain a number. We use this function to get the number of entries in a number field in an array of numbers. The formula one can use is G1:[…..]: = COUNT(G1:[…..])