I have a column from A1:A398 in a Google spreadsheet. Each cell either has an "f" or is blank. I want to count how many of each there are. In row 399, 400 and 401 I put the following formulas


However the formulas aren't doing anything. I expected the counting to take place and the value to be displayed in the cell once I hit return (as it did for me in Excel when I used to have it), however, Google spreadsheets is just showing me the formula. Based on what I've told you and how I wrote the formulas, is there a reason why they aren't calculating?


1 Answer 1


It sounds like you have All Formulas checked in the View menu. Go to the View menu or press Ctrl + ` (backtick) to toggle the view on/off - you should then see it alternate between the formulas and the calculated values.

  • Depending on the version you use, this setting might also be on the ribbon "Formulas".
    – ben
    Jul 14, 2014 at 11:52

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.