This tag is for spreadsheet questions where the question or answers involve an in-the-cell worksheet function, as opposed to some form of code.

learn more… | top users | synonyms

3
votes
3answers
5k views

Are Excel formulas and Google Spreadsheet formulas the same?

I want to be sure all my Google Spreadsheet work can be converted OK to Excel. How many of the Excel formulas match the formulas of Google spreadsheets?
9
votes
2answers
7k views

Sum of all cells in Google Spreadsheet where matching row fits a value

I want to return the sum of all cells in ColumnA only if the value of a cell on the same row is equal to a specific value. For example, sum C4 if D4 = "Bob". Assuming there are six rows whereby ...
2
votes
1answer
209 views

Monitor webpage changes using Google Docs

I want to monitor a webpage. The best solution I found was Google Docs (apart from feed43 which has limitations). I'm using the import HTML function in Google Spreadsheet which will update the cell ...