All Questions
Tagged with worksheet-function spreadsheet
223
questions
1
vote
2
answers
2k
views
Excel: using a formula to only sum from above row until next blank cell?
I'm a bit of a noob so bear with me. I'm making a spreadsheet of various products bought and sold at various prices. The table is sorted by product, with a blank row separating each complete buy-sell ...
1
vote
1
answer
41
views
Incrementing dates after a certain number of entries (in this case 9)
I would like for a date to increment after 9 entries like the below:
1/1/2018
1/1/2018
1/1/2018
1/1/2018
1/1/2018
1/1/2018
1/1/2018
1/1/2018
1/1/2018
1/2/2018
1/2/2018
1/2/2018
1/2/2018
1/2/2018
1/2/...
1
vote
1
answer
762
views
golf statistics in excel
I this this is a very simple answer to a simple problem but I cant work this out. In my golf stats the cell contents in row 1 are the par of the hole, and row 2 has my score for each of the holes.
I ...
1
vote
1
answer
82
views
How to determine largest individual value in excel in a group of identical cells?
I am trying to figure out Column D Which SKU has highest total? how do I do that in excel with a formula? In this case I determined it manually, I tried IF=IF(A2=A3,IF(C2>C3,"Largest","NOT Largest")) ...
1
vote
1
answer
446
views
Count number of cells that match certain criteria with formulae
Suppose I have column with dates:
2015-01-10
2015-08-12
2014-01-02
2015-01-28
2016-10-14
I want to count how many dates fall to January. I would supopse that formulae is like this COUNTIF(A1:A20,"...
1
vote
1
answer
6k
views
Filtering by currency in Excel
I have this situation in Microsoft Excel:
Cells are formatted by using "Format Cells" and setting the Currency manually for each cell. So, they are not simple strings. I would to sum filtering by ...
1
vote
1
answer
70
views
Coloring cells across multiple excel sheets in an xls file based on a condition
I am new to excel. I have an xls file with 10 sheets. In each sheet I have two tables of size 10 x 10, one starting at position A4 and the other starting at N4. All the entries are numbers.
(Note that ...
1
vote
1
answer
121
views
What's the mathematical, =SUM() equivalent of the =NPV() formula, in Excel or Google Sheets?
Is there an Excel/Google Sheet SUM formula equivalent to the NPV formula, ie. one that produces an exact same answer given the same input figures?
The question might be similar to these ones but the ...
1
vote
1
answer
207
views
Drag to fill duplicates values
I want to create a sequence of dates that populate a column.
A
2023-12-31
2023-12-30
2023-12-29
...
Format Cell is set to Date.
Calculation Options is set to Automatic
Enable fill handle and ...
1
vote
1
answer
449
views
How to copy rows of specific columns based on a criteria (and then continuously update)?
I have 2 sheets, let's call them sheet 1 and sheet 2.
In sheet 1, I have some data where essentially at its core its a Scoring tally, something like this:
Name
Age
Gender
Score
Jack
12
Male
155
...
1
vote
1
answer
286
views
How to calculate max sum held over a month?
I need help with a formula that needs to calculate the max sum held at one time for each month.
In this example it would be 54 for March (12+13+14+15, held on the 29/03/2021). Month is determined by &...
1
vote
1
answer
86
views
Sum and lookup over range in spreadsheet
I have a google spreadsheet that looks like this
Items
Item
Value
A
10
B
12
C
15
D
20
Calc
Total
Items
A
A
B
A
A
C
C
C
In Total I want to have the a formula that sums the value of the ...
1
vote
1
answer
44
views
Finding the Last Non-Empty Cell in a Row With a Particular Set of Values
I have a spreadsheet of student data, where each row is a single student. For any given class, there are multiple columns 1-N, where N is the most number of times any of the students has repeated the ...
1
vote
3
answers
112
views
Display a string from another cell, cutting off any word fragments
I'm using this simple formula.
=LEN(A1,20)
But I want it to be able to cut off at the last space in the fragment so there aren't any incomplete words. How can I do this?
Here is an image of the ...
1
vote
2
answers
77
views
Output matched value based on range
I have a spreadsheet with two tabs: one is a search term data from an Adwords campaign and another one is a list of text fragments.
I want to use a function to return check if the search terms ...