Questions tagged [sum]
The result of adding two or more quantities together.
15,625
questions
-3
votes
0
answers
30
views
Get sum of values in multi array [duplicate]
I have an array with different keys, and I am interested in the sum of the values of only the ones that start (or contain) "MT".
$json = file_get_contents($path2);
//echo $json.'<br&...
2
votes
5
answers
114
views
multiple times addition of two columns with dplyr
Assume I have a tibble (in my example here only with four columns). In real I have two hourly time series therefore 2 times 24 columns:
s1.x,...,s24.x, s1.y,...,s24.y
Now I want to sum up column s1.x ...
0
votes
1
answer
30
views
SOLVED Summing up filtered html columns takes to much time, how to speed it up?
With my very basic "knowledge" in javascript I have written the following generic function to sum up filtered columns (i.e. the content of the visible <td> elements of a filtered ...
0
votes
1
answer
37
views
How to put sum of dataframe column in certain cell of excel sheet?
I have multiple dataframes and for each of them I am creating a separate excel sheet. After I've done this, I want to add for each sheet the sum of a certain column.
I have tried to create a ...
0
votes
0
answers
31
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 ...
2
votes
4
answers
70
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
21
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
39
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
58
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
38
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
39
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
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
12
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
59
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,...