Return SUM of all cells that fit TWO CRITERIA related by POSITION
I’m able to use SUMIF to return sum of all cells that fit one criteria:
Cannot sum the value from Google sheet with QUERY and IMPORTRANGE
I have a Google sheet with the budget details, another one is the summary, I have no idea why the first-row value cannot be summed if I
Difference between sheet and file (Android and Apple)?
is there a difference in using Google Sheets on Android or Apple?
My problem is, that I created a Google Sheets File for sharing it with a link so that everybody else can work with it, too.
If I’m sending the link with an android smartphone, the link contains the word “sheets” and the file is accessable for everybody, no matter if they have android or apple.
But if I’m sending the link with an apple smartphone, the link contains the word “file” instead of “sheets” so that the file doesn’t open in Google Sheets but in a browser where it’s not accessable to change anything in it.
And yes, I created the link in Google Sheets the same way on android as on apple – the link is all the same but the word “sheets” and “file”.
Is this an apple problem? Or how can I change it, that it’s automatically an “sheets-link” allthough created in apple?
thanks for your help
Return LAST CELL POSITION based on TWO criteria
I’m having trouble returning the LAST CELL POSITION based on two criterias:
Adding more (3rd) criteria to COUNTIFS
i’m creating a log to record replaced ropes at a climbing gym, with various “averages” output for overview.
Map in google sheet
https://docs.google.com/spreadsheets/d/1DV15JnkvrHAzv4zLaUQIdxMSglDnkXSR-FpVLoKo4Rc/edit#gid=0 – map
Can you set a cell range based on the number of rows in Google Sheets?
Part of my macro inserts a formula into a cell and then copies it down to by a number of rows. The number of rows changes from sheet to sheet based on the content of one of the columns. I don’t want to copy it down to the bottom of the sheet as there is other content below my main table.
Target a Google sheet by its position
Is it possible to target a Google sheet by its position?
My script changes the title of the sheet to todays date so it’s not a fixed title. The script also moves the position of the sheet to the left making it always the second sheet.
query or formular to count this week and comparison days a week before
I have a sheet. I the first Column there is the date of every day in the year (ddd dd.mm.yyyy).
In the second Column there are the values.
How to coerce text using IFS function in Google Sheets?
I have a text in the cell A3 =SCHOOL