## Monday, October 15, 2012

### yogi_Compute The Numbers Of Meetings Attended By Person When New Meetings Added To The Right Of Column B

Yogi Anand, D.Eng, P.E.      Google Spreadsheet   Post  #808  Oct 14, 2012    www.energyefficientbuild.com.

Hi!

I'm trying to figure out why this works:

But this doesn't:

It returns "Unknown range name H3)."

I'm trying to make a spreadsheet that will do a countif from the seventh column to the end, regardless of whether I add new columns to the beginning of the range (it's an attendance sheet for meetings, with names and other data on the far left side). Adding \$ doesn't seem to make a difference - the formula I enter as:

=Countif(\$G3:3,1)

Will change automatically as soon as I add a new column at G to:

=Countif(\$H3:3,1)

Hoping that makes sense! Thanks in advance for any advice you are able to provide.
----
OK, thanks for the reply, Yogi!

I have written the formula as =SUM(INDIRECT("G3:3")), and it does work as expected, but I want to be able to autofill the formula down a column.  I am trying to count the values in one row all the way to the right (I'm only using SUM as an easier test).  If I write =(INDIRECT("G3:YY")) and then autofill down the column, I will get "G3:3" in every row instead of "G3:3" in the first row, "G4:4" in the second row, etc.

Here's an example of what I'm trying to do:

Again, I appreciate the help!
-----------------------------------------------------------------------------------------------
following is a solution to the problem in the spreadsheet link provided by user obstruction