All Questions
172
questions
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
451
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 &...
- 23
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 ...
- 11
0
votes
1
answer
321
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 | ...
- 557
3
votes
1
answer
248
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 ...
- 131
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....
- 3
0
votes
1
answer
317
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 ...
- 8,487
0
votes
1
answer
991
views
Excel Change value of each cell with a value in row to count+1 of cells with values in row
I have the following spreadsheet:
I have 57 rows and ~750 columns, in some cells I will have the number one. I want to change the cells with one to a rolling count for each row. I have shown what I ...
- 117
0
votes
0
answers
34
views
Sorting an excel column with numbers and keep track of cell indices
So, this is my problem, I have two excel columns like :
1 // 0.5
2 // 3.3
3 // 1.2
I would like to sort the second column in ascending(or descending) order, and also change the first column as ...
- 1
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 ...
- 23
0
votes
3
answers
3k
views
Is there an option or setting that prevents VLOOKUP from returning zero when it finds blank cells
Is there an option or setting that prevents VLOOKUP from returning zero when it finds blank cells or does not find the lookup value.
I do not want to suppress the zeros by formating them out. I want ...
0
votes
2
answers
41
views
Function that writes name depending on two conditions
I would like to know how to implement this in an excel formula: I have a column with some names, a row with different numbers (dates), and the remaining values work as "keys". For instance:
...
- 1
0
votes
2
answers
164
views
How to write an Excel Formula that takes a total across multiple repeating rows [duplicate]
I'm working with payroll data in a spreadsheet. What I'm looking to find is a total across different rows of employees with different roles. For example, how could I write a forumla for the "...
- 1
0
votes
1
answer
68
views
Sumifs function in excel
Hi my SUMIFS function is not adding up figures at all. The SUMIFS formula I use is below:
=SUMIFS($O:$O,$A:$A,"distribution - reinv",$D:$D,">="&DATE(1,5,2020),$D:$D,"&...
- 1