15,677 questions
0
votes
1
answer
44
views
Need to have excel average every nth row only with data in it
I have a weekly scorecard that our leadership is going to fill out. Its all on one tab and has 500+ rows of the same scorecard that runs with the same statistics. I took a screen grab of one section. ...
- 1
-2
votes
4
answers
123
views
How to iterate multidimensional array data and sum some values to return a grouped array
What's the simplest way and uses less computing power to check if a multidimensional array has some equal values in the sub keys and, if is in this way, make the sum of that?
Look at the input. It's ...
0
votes
3
answers
58
views
SUM on google sheet always returns 0
The sum on my spreadsheet column Category always returns 0.
I have formatted column Amount as Number but still it doesn't work. I had also removed all currency symbols from that column using find &...
3
votes
8
answers
255
views
Cumulatively sum values in a column based upon a Y/N indicator
I am trying to get my head around an MS excel formula for a scenario I have:
I am recording volume sampled and I would like a second column (B) that cumulatively sums the values in A until a Y/N ...
- 33
0
votes
1
answer
69
views
Excel return sum of variable date in row where criteria is met
I need to find a date in a row 3:3, and then add all the amounts in that column where in a different column A:A the text is = to a specific criteria
Criteria
1/1
1/2
1/3
Bob
1
4
2
Sue
3
1
3
Jill
1
...
0
votes
2
answers
59
views
Sum column A based on condition with color on other column
Let's have table like this:
I would like to put the SUM of D5-D7 in cell H10 IF their corresponding cell in column H is colored. I would do the same for all the rest of the dates.
The result shall be ...
- 45
1
vote
0
answers
18
views
how to auto sum the calculated field
I have below pivot table and calculated field column in excel. Not able to get the grand total for calculated column.It is simply subtracting the value 1 from 'num' column as per calculated field ...
- 63
0
votes
1
answer
107
views
MySQL Query takes too much time with SUM & GROUP BY
It significantly reduce the time to below 1 second when I removed sum & group by parts from the query.
It takes 2 minutes to execute the above query, and each table has only 95000 rows except the ...
0
votes
0
answers
16
views
Tabulator Sum of all groups
I am using tabulator to show my data State and City wise, grouping works fine but when added SUM of all groups, its only calculating of "CITY" only.
groupBy: ['State', 'City']
columnCalcs: &...
- 1,445
0
votes
1
answer
43
views
make a colum total in flutter datatable
i would very appreciate any one who can help. I wan to make a column in a table which is come from summarize of col 1 + col 2 + col 3 in every row i tried this code but the result is not summarize but ...
1
vote
3
answers
56
views
How do I find the highest sum of multiple cells in column A where the sum is based on multiple cells matching in column B in Google Sheets?
I deeply apologize for the title being unclear. It is difficult to explain what I am looking for in such a small amount of characters. To provide some background, see the table below for reference.
...
- 15
0
votes
1
answer
111
views
SQL Group By and Order by with sum
I have this query:
--10/24/24 - UNIT PRICE AND QTY SHIPPED
SELECT
DBO.SHIPPER.PACKLIST_ID, dbo.shipper.SHIPPED_DATE,
DBO.SHIPPER.CUST_ORDER_ID, dbo.SHIPPER_LINE.SHIPPED_QTY,
dbo....
- 931
1
vote
2
answers
76
views
A more pythonic way to filter out even numbers from a list and calculate the sum?
I have a list of numbers in Python, and I’m trying to get the sum of only the odd numbers. I know I can use a for loop, but is there a more Pythonic way to do this?
Here’s what I have so far, but it ...
- 13
0
votes
0
answers
37
views
Mysql SUM inside Left Join return wrong value when using with rollup function
Good Afternoon. I have some problem/missunderstood with rollup function when using LEFT Join statement. the sum from rollup at the end is not like my expected. how i can correct the last sum of result,...
- 7
1
vote
2
answers
80
views
DSum mistake in choosing the right database records with multiple criteria in 3 fields
In the following Google-sheets database, I cannot get the choice of correct records with multiple criteria in 3 fields.
Plant
Number
Field
Expire date
Oak
10
A
2034-11-01
Cherry
5
B
2026-04-01
Elm
...
- 15