# Tagged Questions

7 views

My Google spreadsheet created on my PC won't open on the Drive application on my tablet or phone. It opens in the browser but won't allow it to be edited. The error on Google Drive: Failed to open ...
84 views

My Google spreadsheet created on my PC won't open on the Drive application on my tablet or phone. It opens in the browser but won't allow it to be edited. The error on Google Drive: And my ...
10 views

### In Google Spead sheets how do I find the average amount spent in a month?

I've been keeping track of purchases and would like to do some statistical calculations. In column B there is the price in the form \$X.YY and column C has the date in the form mm/dd/yy. How can I find ...
76 views

### Google Drive spreadsheet - create chart with total for each score

I have a column within a google spreadsheet with values like this: 96 97 96 100 97 97 100 97 95 95 96 I'd like to add a bar chart where each bar represents one of the values and the height of the ...
47 views

I have a Google spreadsheet with 1,500 cells containing items like: 1,300 users 2236 users, 12 companies 15000 users,153 companies <46,000 users, <200 companies I need to split this ...
34 views

### How do I split multiple rows / insert a row below every existing row, in any spreadsheet program?

I use a spreadsheet to keep track of journeys in a lift-club. Each day has its own row, and the number of lifts given to a person will be 0, 1 or 2. I realized that the algorithm for the lift scheme ...
18 views

### How do I merge cell data into a new column?

A | B ----- 1 | a 2 | b 3 | c and I'd like to have a third column that merges the data like this: A | B | --------- 1 | 1, a 2 | 2, b 3 | 3, c currently I can kind of do this one row at a time ...
50 views

### Entering time data quickly using code for a specific range of cells

What API code do I use if I want to quickly enter 24 hour times (without entering the colon and still retaining time formatting) for a certain range of cells? I know the following code works for ...
52 views

### Spreadsheet: function to watch row for changes

Is there a spreadsheet function (Google, Excel, Numbers, or otherwise) that can watch a row and update a cell with the current date when any cell in that row changes? If not for the entire row then ...
72 views

### How to anchor all the cells on the page in Google Spreadsheet

To anchor cells in a Google spreadsheet so that you can drag the values/cells/formula, with one or more of the linked cells/values remaining constant you can follow these steps: ...
78 views

### Google Sheets: Find the maximum occurrence across sheets

This is kinda difficult to explain... Is it possible to let Google Sheets tell me what the maximum value is from some chosen coloumns in MORE THAN ONE sheet (in the same document)? I namely need to ...
319 views

I'm trying to drag copy some cells, which are on top row for headers, they get their values from a VLOOKUP formula (Basicaly all group names are in column B and I want them as column headers). Before ...
1k views

I have a client that wants a simple online database or spreadsheet solution. Requirements Custom fields and field types (text, images) CRUD contents through a web GUI Password protected (single ...
1k views

We're looking at a way to share inventory information across multiple users: sales, customer service, production, etc. Is there a way to lock the 'Price' column so that it can be edited only specific ...
5k views

### Multiple Conditions on a CountIF?

I have a spreadsheet that is essentially a todo list for different groups. I have a column for Group and Status. Both have data validation drop downs so I can reliably match the text content. I have ...
2k views

### In Google Spreadsheets, how do i remove the '0' from a field with an equation?

I have a spreadsheet that i enter in new values everyday and want to have the equation run down the entire column so i don't have to drag the previous day's box down to copy the info. It would work ...
11k views

### How to make a query with Google Spreadsheet, that checks for a date

I have a range that goes from B4:H124. All the cells in column B are dates. I would like to retrieve the data from a row (B:H), where the DATE equals to the content of a specific cell, lets say Q4. ...
9k views

### How to sum ​​values ​​in a range of dates in Google Docs Spreadsheets?

I have a Google Docs spreadsheet in the format below — here's an example. Column A → Dates Column B → Numbers I'd like to sum values ​​in column B in a range of dates in column A. Example: ...
9k views

### Sum column only if another column has an empty value

I am trying to get a sum of column values in a Google Spreadsheet only if there is no value in the adjacent column. Consider the following example: A | B ---------- 40 | 50 20 | 20 30 | 10 | ...
10k views

### In a Google spreadsheet, how can I refer to two different columns in a COUNTIF function?

I'll try my best to explain. Say I've got a sheet that looks like this (in this contrived example, let's say I'm sending marketing emails to various people, I know their ages and zip codes, and I ...
4k views

I have a spreadsheet that keeps a running balance of a credit card with the newest transactions at the top (just like credit card web sites). An example of the formula for each cell in the Balance ...
2k views

### How to freeze a row height or prevent line breaks in Google Spreadsheets?

My question is very similar to a previous question here, but I don't want the scroll bars. When I paste a link in a cell it usually breaks the cell in multiple lines, increasing the row height. Even ...