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?

migrated from superuser.com Jul 19 '14 at 2:36

This question came from our site for computer enthusiasts and power users.


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 '14 at 11:52

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy