I have a formula that is supposed to count the first 100 rows in a group of cells.
I use this formula =COUNTIF(($B$2:$F$101),R2) Whenever I insert cells at the top, the formula changes. For example, if I insert 10 rows of cells at the top. the formula changes to =COUNTIF(($B$12:$F$113),R2) which is, technically, no longer counting the first 100 rows anymore. How do I "protect" the original formula so that it doesn't change when I add rows? -- You received this message because you are subscribed to the Google Groups "Google Spreadsheets API" group. To unsubscribe from this group and stop receiving emails from it, send an email to google-spreadsheets-api+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/google-spreadsheets-api/573acab8-3af1-42dd-a92d-bf2f617cea52n%40googlegroups.com.
