With almost universal availability of Internet and the availability of reliable on-line productivity tools, such as Google Docs, individuals as well as companies are switching over to Cloud Computing. In this blog I will post items of interest to my colleagues/patrons/clients.
Monday, October 15, 2012
yogi_Compute The Numbers Of Meetings Attended By Person When New Meetings Added To The Right Of Column B
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:
Will change automatically as soon as I add a new column at G to:
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.