GoogleDocs Spreadsheet Super Challenge!
November 26, 2008 8:11 AM Subscribe
ExcelFilter: I need to make a cell in one column tell another cell in that row to add itself to another cell somewhere else entirely. Added difficulty! I need to do this in Google Docs.
posted by greenland to Computers & Internet (3 answers total) 1 user marked this as a favorite
I have a sheet where one column (column C) will only have five set text values. (And by set values I mean there will only ever be one of five things that are typed in a cell in this column. I don't mean that Excel knows what these values are.)
Whenever one of these five values are entered, there will also be a numerical value typed in a different cell in that row (always in column G). That numerical cell gets summed into a numerical cell on a different portion of the sheet.
What I'd like to do is have the sheet recognize when one of the five text values is typed into column C and have that trigger the sheet to automatically add whatever is in column G to the sum in the ensuing cell (H3 for our purposes here).
So, for example: cell C12 has "Graphics" typed into it, then "4" typed into cell G12. I would like G12 to know that it has to automatically add itself to the sum in cell H3 based on the fact that "Graphics" has been typed into C12.
Unfortunately, I need to do this in Google Docs' spreadsheet program. Is this even possible?