Questions tagged [sum]
The result of adding two or more quantities together.
15,624
questions
2
votes
4
answers
54
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 ...
0
votes
1
answer
16
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
55
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
33
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" ...
0
votes
1
answer
35
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)
...
-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 ...
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"))....
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]...
1
vote
2
answers
56
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,...
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
...
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 ...
-1
votes
0
answers
16
views
I need a function to Get the Length of the SenderDomains under some InboundConnectors in Exchange Online
I found this function to get the Lenght of 1 InboundConnector for the field "SenderDomains" in ExO:
Get-cloudInboundConnector -Identity "Inbound Required TLS 2" | select -...