Formulas used in Spreadsheets

learn more… | top users | synonyms (1)

0
votes
1answer
40 views

Google Sheet Cell Link to Google Form test score

I have a pre-made Google Sheet which has cells to be marked as "pass" or "fail" depending on the person's score. Is it possible to link a Form response to record a pass or fail mark depending on the ...
-2
votes
1answer
958 views

Simple row references in Google Spreadsheets and resorting data

This is my scenario Users are entering data into rows with several columns Last column is calculated on values of few previous columns (so it's row number independent). While entering new and ...
1
vote
0answers
47 views

Counta Function Counting One Extra Filled In Line

I am creating a register for some workshops to introduce people's personal information, organized by when these workshops are taking place. I have six different spreadsheets (Monday, Tuesday, ...
1
vote
0answers
40 views

Is there a way to do collaborative equation editing in a Google Presentation?

Since Google Docs now forbids equation in presentations (you cannot drag equation from doc anymore according to this question). Is there a way to include equations in a Google Presentation?
0
votes
0answers
99 views

Formula query to perform dynamic sum

I am creating a spreadsheet which looks up values from a second sheet. I need to SUM various sections in the sheet but these are variable - the row that needs SUMing can change at every fresh import ...
0
votes
0answers
1k views

Complex Index and Match with three criteria

I need to create a formula that will match three criteria in a range on another sheet, and where they match, return the value in an adjacent cell. The problem I have is that one of the criteria is a ...