New answers tagged

0 votes

Counta and Array_constrain formula in Google Spreadsheets

To get the numeric part of the report, use query(), like this: =query( A1:K; "select G, count(G) where B contains '" & N19 & "' group by G pivot F"; 1 ...
doubleunary's user avatar
1 vote
Accepted

Hide a value in a cell unless another cell has a given value

Put this formula somewhere on the same sheet or another sheet and point your dropdown to the column where you place it. =FILTER( SEQUENCE(50), COUNTIFS( A2:A1000, SEQUENCE(50), C2:...
Blindspots's user avatar
  • 4,230
0 votes

Combine different sheets with importrange for dynamic data from google forms

You shouldn't use importrange() to copy data within a spreadsheet file. Use a cross-sheet reference instead. To merge data from several tabs, use reduce() and vstack(), like this: =let( ...
doubleunary's user avatar
1 vote
Accepted

Googlel Sheets formula to SUMIFS with multiple AND and OR criteria

Formula =LET(rng, A2:I, dt, "2/1/24", rg, "NorAm", tm, "Corporate", dif, LAMBDA(c,  ARRAYFORMULA(IFERROR(1/(1/INDEX(rng,,c)) <= dt))), SUMPRODUCT(INDEX(rng,,...
Blindspots's user avatar
  • 4,230
2 votes

Googlel Sheets formula to SUMIFS with multiple AND and OR criteria

You would need more than one cell/column depending on how you implement. I'm assuming you want both bulletpoints as requirnments, as well as the ability to switch what they are searching for in the ...
Doragon's user avatar
  • 139
0 votes
Accepted

Populate cell based on unique values from two fields

Use map() and filter(), like this: =map(A2:A, B2:B, lambda(color, name, if( rows(filter(B2:name, A2:color = color, B2:name = name)) = 1, 1, iferror(ø) ) )) If you just want to ...
doubleunary's user avatar

Top 50 recent answers are included