Questions tagged [sum]
The result of adding two or more quantities together.
15,622
questions
0
votes
0
answers
30
views
Adding Average at the very last part of the row and column in a dataset
I have a sample dataset of total outbound calls, it comprises rows (dates) and columns (hourly), my goal is to show totals and average of outbound calls per day (rows), and the totals and average of ...
- 143
2
votes
4
answers
61
views
How do I merge multiple dataframes and sum common values into column
I have many dataframe like:
df1 df2 and so on...
gene | counts gene | counts
KRAS 136 KRAS 96
DNAH5 3 DNAH5 4
TP53 105 ...
- 57
0
votes
1
answer
19
views
Modifying a Complicated Map Formula to put in Header
I've got a complicated formula that I don't understand:
=map(A2:index(A:A,match(,0/(A:A<>""))),lambda(Σ,if(Σ="",,map(BZ1:CW1,lambda(Λ,let(x,index(sumifs('Ref4'!Q:Q,'Ref4'!G:G,...
1
vote
1
answer
38
views
How to stop the second console.log from including the array of the first in its calculations?
I made a function that will find the sum of whatever array you put in. The problem is that if I have 2 of these console.log up, the second will add the sum of the first to it's result. What am I doing ...
-1
votes
2
answers
56
views
Why do I not get the more helpful "sum() can't sum strings, use join" message, but "unsupported operand types for +"?
I'm learning Python now.
I created a function
def my_func(my_tuple):
return sum(my_tuple)
Then I do
print(my_func(("a", "b")))
And I get:
TypeError: unsupported operand type(...
2
votes
0
answers
35
views
How to sum values until a certain text value is reached
Below is a sample of my data
This is data from a pipe model I created. I am trying to create an excel formula that returns the lengths between bend points (i.e. summing all lengths of "run" ...
- 21
0
votes
1
answer
37
views
Arrayformula to SUM matching ID AND when date is between two dates
SUMIFS and/or QUERY inside ARRAYFORMULA
The problem explained above is a simpler, but very close approximation of what I'm trying to do. I'm looking to split up the 12 month year into 24 segments, the ...
-2
votes
0
answers
48
views
Why can't I take the sum of column values with the same name and replace them all with a column with the same name and those sums in pandas? [closed]
Bar = df.groupby('Explicit Track')[df.columns[7:-1]].sum()
Bar.columns = [Bar.columns.to_list()[i].split(' ')[0] for i in np.arange(Bar.columns.size)]
Bar['Pandora'] = Bar['Pandora'].sum(axis=1)
...
- 1
-2
votes
1
answer
92
views
Overflow while performing addition in one way and getting correct output in other way but why? [duplicate]
I am writing code and it has a line where a, b, c, d are integers,
int a, b, c, d;
long long sum = a + b + c + d;
I get an overflow error, but after referring answer and modifying the sum as below ...
- 9
0
votes
0
answers
10
views
Office Script Excel Pivot Table Sum is not working for the format h:mm
I'm using Office Script to generate a pivot table and for summarize using following script where Due is in the format of h:mm
pivotTable.addDataHierarchy(pivotTable.getHierarchy("Due"))....
- 1
0
votes
0
answers
42
views
c++ summ up some float values using 2 decimals [duplicate]
I try to sum upp some float values in c++, 65769.59+13.95 = 65783.54 using calculator, but i get 65783.55 in my c++ code why?
I tried
float t_amount = 13.95;
float total_amount = 65769.59;
char buf[20]...
- 19
1
vote
2
answers
58
views
Complicated triple sum in pandas dataframe
I have a pandas dataframe that looks like
import pandas as pd
data = {
"Race_ID": [1,1,1,2,2,2,2,2,3,3,3,4,4,5,5,5,5,5,5],
"Student_ID": [3,5,4,1,2,3,4,5,4,3,7,2,3,9,10,2,3,6,...
- 223
0
votes
2
answers
47
views
SQL - How to Sum every line with record-3
It's dificil ton explain, i want to Sum the 3 last row for every row. An exemple will be better :
ID VALUE1 RESULT I WANT
===================
1 10 10+5+20 = 35
2 5 5+20+4 = 29
3 20 20+...
0
votes
2
answers
34
views
Google Sheets lambda or match() function?
I'm struggling with formula.. I want to sum in column K, when code in column H match code in column J. I thought I'd try a pivot table, but again something didn't work properly..?
Google Sheet example
...
- 1
2
votes
2
answers
65
views
Compute the sum of the previous group of rows and the sum of the current group of rows in SQL
I have a SQL table containing profit for a customer group, customer, project and year. I want to add the sum of the profit of the previous year for the current customer group and the sum of the profit ...
- 772