All Questions
Tagged with worksheet-function spreadsheet
223
questions
1
vote
1
answer
25
views
finding difference in two columns of a spread sheet?
lets say I have 3 columns
A B C
1 2
2 3
4 5
and i will go on entering numbers in A and B, in C I need to have the difference between col B and col A, can I write a single formula for ...
0
votes
2
answers
1k
views
Excel Formula to increment day by one except if it's a weekend
Basically what i want is for weekdays to increment by one every day but for weekends i want each day to display twice, so each weekday will have one row and each weekend will have two the current ...
2
votes
1
answer
1k
views
CONCATENATE cells in a column IF condition in other colum is met
Using Google sheets (or Excel if Google sheets can't do it). I'm trying to concatenate any cell in B column, if its corresponding A cell is "include". The columns are very long and therefore ...
0
votes
1
answer
236
views
Excel - sort one spreadsheet by exact order of second spreadsheet based on one column with same data
I trying to find a way how to sort one spreadsheet into the same order like second spreadsheet - based on their one same column for example.
Here's an example what i need, i will make more sense like ...
0
votes
1
answer
1k
views
i want to return value( eg;- sum) only if the source is not blank,other wise return blank !!not zero!! in excel, wps
see this screenshot for reference
see this screenshot..
I used SUM formula in the botton cells to get sum of all values from each row , the bottom cells display TOTAL
and i will assign the TOTAL ...
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 &...
0
votes
1
answer
2k
views
Based on cell formula, display another cell value
I want Excel to look into the formula of a cell and then display a different cell based on that. confused yet?
Column A on sheet 1 has a size and column B on sheet 1 has a tolerance.
Could be same ...
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
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 ...
0
votes
1
answer
319
views
Count number of rows with a specific MONTH in the date of a specific cell and a boolean condition in another cell
Let's say I have a number of dates and whether they occupy full or half a day...
DATE | WHAT | HALF?
...
2021-4-1 | Something Something | false
2021-4-2 | Something Something | ...
3
votes
1
answer
247
views
Filtering over merged downwards cells in MS Excel-2016
Note: This question has been asked back in 2010 on this site here. And yet, I would like to post it one more time, showing what I did and what didn't work. Besides, Excel has changed quite a bit since ...
0
votes
3
answers
148
views
Sum of vlookups for each value in a row
There should be a way to do this, and yet I'm struggling...
==The Data==
Sheet1
A B
+---------------+-------+
| Fishy_Product | Price |
+---------------+-------+
| Cod | $9....
0
votes
1
answer
316
views
In LibreOffice Calc, is it possible to use a complex function and a data range as arguments for a MIN() function?
I'm going to simplify a bit to hopefully get at the crux of my question.
I have a spreadsheet in which a cell has a massive formula. (Again, I'm simplifying to avoid a question that is so long no one ...
3
votes
3
answers
3k
views
Using VLOOKUP for multiple lookup values, then summing the outputs
Example:
I have a sheet listing the number of calories for various foods.
In another sheet I have a list of some of those foods to be used in a meal, and would like to calculate the total number of ...