0

I want to count cells which are not blank in another sheet's last column.

Now I'm using this formula in sheet1:

=COUNT($'Sheet2'.H11:H54). 

At the end of every month I add 2 columns to sheet2.

How can I change my formula to work when I add extra the columns?

0

On sheet 2, select the range H11:H54 and give it a name by clicking in the box to the left of the formula bar. For example, LastColumn.

Then, change your formula to =COUNT (LastColumn).

Whenever you add columns to sheet 2, redefine the name LastColumn to refer to the new last column. They way you will not have to change the formula on sheet 1.

  • What's the difference of changing the formula or redefining the name every time? The idea of the question is; the formula should always look at the last column of the range, and shouldn't require monthly maintenance. – User15 Sep 9 '15 at 14:11

Your Answer

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

Not the answer you're looking for? Browse other questions tagged or ask your own question.