All Questions
Tagged with worksheet-function spreadsheet
223
questions
2
votes
2
answers
59
views
How to sum two categories within a single column and show the totals to the side of the column?
I have a list of trailers with a column to the side that says if the trailer is full or a pup trailer. I can't figure out how to make the column total how many of each type of trailer and show the ...
2
votes
1
answer
686
views
How to set a whole row equal to a value, using ARRAYFORMULA() ? (in Google Sheets)
I would like to set the contents of all cells in a particular row to have the same value, sort of like having a banner that runs across the entire width of the spreadsheet. I'm working in Google ...
2
votes
1
answer
94
views
Change shelves into separate columns
Every day I have an inventory to do. 100 or so items on 15 or so shelves. I also have an xml report that shows what should be available in the room - but this xml does not show what shelves the items ...
2
votes
1
answer
188
views
Merging different number of rows with some common data
I have a data like this in an excel sheet:
Rensi 06/10/2020
Rensi 07/10/2020
Rensi 08/10/2020
Sam 06/10/2020
Sam 08/10/2020
Mathew 07/10/2020
I want to ...
2
votes
1
answer
69
views
How can I look up the 2 axis values by inputting a number?
I'm a graphic designer and not very familiar with Excel but I'm fairly sure it's the simplest solution to my problem. I have a table (see below) with 2 axis going from A to L. Inside that table are a ...
1
vote
3
answers
19k
views
Display real-time filtering data from another worksheet in Microsoft Excel
I want to display all rows that have a "Gender" column equal to "M" inside "sheet2", where the data is retrieved from "sheet1". The filtered data also has to be ...
1
vote
2
answers
15k
views
Simple pattern with Excel COUNTIF to match a substring?
How do I fix this formula: =COUNTIF(A1:A10,"*jim*") to match anything containing the sub-string of "jim" but from a cell, as: =COUNTIF(A1:A10,C11) where cell C11 contains the text "jim"?
Perhaps ...
1
vote
1
answer
7k
views
How do I add values in column B if column A contains the same employee surname more than once?
State of Data: I have column A which has names of employes and column B has number of hours. How do I add the hours if column A contains same employee surname more than once?
I have been using what I ...
1
vote
2
answers
31k
views
How to select and copy entire row based on text-value in a cell in excel
I would like to do the following:
Find all cells containing a certain keyword in a column in an excel spreadsheet.
Select and copy the entire row which includes the cells which have the keyword ...
1
vote
1
answer
24k
views
How to sum a column based on existance of value in another column
I have the following sheet:
I want a sum of individual spending by Frank, John and Nancy in the yellow cells. Each person's spending is denoted by an x. I tried the SUMIF formula, but I don't know ...
1
vote
2
answers
63k
views
How to combine multiple formulas in 1 cell
I am trying to combine the below two formulas in one cell, but no luck so far.
Both formulas work OK on their own, but I can not figure out how to combine them together to produce the result in same ...
1
vote
2
answers
1k
views
openoffice calc: sum of a function of elements of a row
If I want to sum the elements of the first row (from the column a to x) of a calc document I can use =sum(a1:x1).
My question is about the possibility to calculate something like this
=sum(a1^2/(1+...
1
vote
2
answers
3k
views
MS Excel: how to use COUNTIF() dynamically
I have a spreadsheet to keep a log of faulty items. Every item is logged onto a separate row and there is a "Usable?" column for each item. This is what and example row looks like:
Item | Usable?
...
1
vote
1
answer
31
views
How to vlookup all columns and sum
I have two table.
The first table contains menu and price:
Menu
Price
Pizza
20
Pie
10
Beer
5
Burger
10
The second one contains a buyer and menu. I want to get the sum of price based on menu like ...
1
vote
2
answers
2k
views
MS Excel - Separate text based on keyword
I need to separate text based on a keyword to different columns. the original text is in one column but I want to split the intended subtext into different columns. The problem in this case is I get ...