python (65.2k questions)

javascript (44.3k questions)

reactjs (22.7k questions)

java (20.8k questions)

c# (17.4k questions)

html (16.3k questions)

r (13.7k questions)

android (13k questions)

Questions - sumifs

Sum Across Multiple Tabs, Only If Tab is Flagged as being Active

I have 5 tabs: "Start" "2020" "2019" "2018" "End" I would like to sum the same cell (eg. cell A2) across all tabs, ONLY if the tab is flagged as being...
test-img

user18729347

excel

excel-formula

sum

sumifs

sumproduct

Votes: 0

Answers: 2

Latest Answer

Assuming: All cells A1 are either empty (thus zero) or a literal 0 or a 1; Access to ms365's TOCOL(). Try: =SUM(TOCOL(Start:End!A1)*TOCOL(Start:End!A2))
test-img

JvdV

Looking for the most profitable range (mathematical names: "maximum subarray problem" or "maximum consecutive subsequence sum")

To be able to find the most profitable range, I add the lowest value I want to the highest value I want, with that I create a table like this example: https://docs.google.com/spreadsheets/d/17zpapBeC5...
test-img

Digital Farmer

google-sheets

google-sheets-formula

sequence

cumulative-sum

sumifs

Votes: 0

Answers: 1

Latest Answer

max: =INDEX(MAX(IF(SEQUENCE(MAX(A:A)+1)>=SEQUENCE(1, MAX(A:A)+1), SUMIF(SEQUENCE(MAX(A:A)+1), "<="&SEQUENCE(MAX(A:A)+1), B:B)* SEQUENCE(1, MAX(A:A)+1, 1, )-QUERY(QUERY( (SEQUE...
test-img

player0

Googlesheets Query to substract Sheets

Example - https://docs.google.com/spreadsheets/d/1dNV8BP6AJfc8-u-8BFkkf1i3_QBLe9U1-YfVfUvRdok/edit#gid=1046241405 Sheet - 1 - data is updated daily Sheet - 2 - data is backed up from 1 Sheet - Diff -...
test-img

Bruno Carvalho

google-sheets

sum

google-sheets-formula

sumifs

google-query-language

Votes: 0

Answers: 1

Latest Answer

in general: 3 + 2 = 5 3 + (2 * (-1)) = 1 delete everything in range B2:G and use this in B2: =INDEX(IFNA(VLOOKUP(A2:A; QUERY({'1'!A:H; '2'!A:B\ '2'!C:H*-1}; "select Col1,sum(Col3),sum(Col4),s...
test-img

player0

SUMIFS and SUMPRODUCT used together

I am working on a project where expenditure across multiple accounts and multiple different currencies are consolidated into a single currency cash flow statement that aggregates the expenditure into ...
test-img

Tony Fiante

excel

sumifs

sumproduct

Votes: 0

Answers: 0

Posts

Questions

Blogs

Jobs