15,726 questions
0
votes
1
answer
58
views
google sheets SUMIF based on other sheet
I have a sheet contains info like this:
Date (A)
Sub (B)
Total (C)
1/20/2026
100
106
12/15/2025
50
60
2/1/2026
25
30
on another sheet, I want to show summed rows by year...for example
year
sub
total
...
- 11
0
votes
3
answers
160
views
Sum of total value for all dates separately in excel based on values from a table
I'm trying to get a report sheet based on another table that contains more data
i have succeeded in creating the date column based on the available dates in the other table using =UNIQUE(FILTER(...
- 131
0
votes
0
answers
171
views
As part of a function, how could I create a variable number of sums one inside another based on a parameter?
I'm currently struggling on an assignment (probability class) which require creating a function (VBA excel) that contains a variable number of sums one inside the other based on a parameter. I'm not ...
- 1
1
vote
1
answer
50
views
Excel formula for Sumif and query generation
In my Excel file, I have two sheets. One is named Airjet and contains detailed data with numerous columns:
Column I lists all the months
column Z lists the yarn counts
I want to extract data into ...
0
votes
1
answer
45
views
Totals from specific parts of a large spreadsheet by row and column
Here is a large spreadsheet with several years' worth of data in a lot of categories.
Y = year, M = month, D = day
A B C D E
1| Y | M | D | 1 | 2 |... Initial dataset
2| 19 | 1 | 1 | ...
- 1
0
votes
2
answers
100
views
How create a dynamic cumulative sum in power query
I want to create a sum in power query (Measure C below) returns the cumulative sum of Measure A + Measure B and is limited to zero and which resets at the beginning of each Period as shown in the ...
2
votes
1
answer
213
views
How to filter and sum elements of a matrix in MATLAB based on multiple conditions without a loop?
I have the following numeric matrix in MATLAB:
A = [3 2 7; 9 1 4; 5 6 8];
I want to sum all elements that are greater than 5 and are also even.
I need to do this without using a loop, and store the ...
- 65
0
votes
0
answers
62
views
Sum of integer data and numeric data is unexpected numeric value, R [duplicate]
Why is the sum of the iaea_mass_dat_trunc$AM_WN (integer) and iaea_mass_dat_trunc$AM_frac (numeric) 499496.6 for all results? How do I get the appropriate result (for example, the sum of the values in ...
- 117
0
votes
1
answer
127
views
Python lambda returns 0 [closed]
Is there a simple way to return 0 with a lambda function using and and or operators?
For example, consider this function to sum elements in an array:
sum = lambda tab: tab == [] and 0 or tab[0] + sum(...
- 1,593
2
votes
3
answers
137
views
Query count & sum nested selects into a Grouped Category
My current project/issue is we have a list of permit types. With these types they are needing to be grouped by an overall category. Once grouped out the end goal is to count how many within specified ...
- 23
0
votes
2
answers
76
views
SAS: Conditionally summing a column without having the lead funtion
I cannot conditionally sum a column where the condition looks at rows further down the table. Below is what I am expecting:
Identifier
MONTH
Sum_Me_Pls
On_Off_Flag
focus
seq
Need
1
May-23
0
0
0
1
1
...
- 3
0
votes
1
answer
144
views
How to sum two columns and calculate their average in BigQuery?
I'm working with Google BigQuery and I have a table with two numeric columns: grade1 and grade2. I want to calculate the total sum of both columns combined (row-wise) and then find the average of ...
2
votes
1
answer
77
views
Is there a more elegant way to write sum in MATLAB code
disto_pow = spectral_pow(h_idx * 2) + spectral_pow(h_idx * 3) + spectral_pow(h_idx * 4) + spectral_pow(h_idx * 5) + spectral_pow(h_idx * 6);
spectral_pow is an array and h_idx is a scalar.
Is there a ...
0
votes
1
answer
146
views
NEW QUESTION: How do I use SUMIFS with IMPORT RANGE in google sheets to sum a column based on referenced criteria (ex: "<="$K$5)?
UPDATED EDITS BELOW
I have a list of downloaded transactions that each correspond to a specific account code? I want to sum the amount (column G) based on the following criteria: segment (column A), ...
0
votes
0
answers
28
views
Sum of vlookups with a partial match: What is the formula, if it exists?
I'm trying to see if this is even possible. I am essentially trying to get a partial match vlookup with the added component of possibly a sumifs formula to get the total amount of pay for each store.
...
