Question

Can I use Sumproduct arrays and check two separate criteria counting TRUE statements?

score 24 · Answer 1 · 2024-03-28T14:45:30.397000

24

Views

Can I use Sumproduct arrays and check two separate criteria counting TRUE statements?

Published on 28 March 2024 at 14:45

score 44 · Answer 2 · 2024-03-27T23:47:52.867000

44

Views

IF AND OR Nested ArrayFormula not working - What am I missing?

Published on 27 March 2024 at 23:47

score 18 · Answer 3 · 2024-03-26T11:00:02.667000

18

Views

Return next not blank result based on a raw

Published on 26 March 2024 at 11:00

score 68 · Answer 4 · 2024-03-21T21:57:09.537000

68

Views

Google Sheets: Return 1st, 2nd, 3rd, etc. instances of strings from range. Prepend values from top row to each string returned

Published on 21 March 2024 at 21:57

score 70 · Answer 5 · 2024-03-20T15:05:26.517000

70

Views

Count duplicates if other cell contains week num google sheets

Published on 20 March 2024 at 15:05

score 40 · Answer 6 · 2024-03-19T18:18:29.603000

40

Views

Waterfall value (get value from previous row to populate the next one) with arrayformula

Published on 19 March 2024 at 18:18

score 40 · Answer 7 · 2024-03-17T13:19:27.840000

40

Views

Find minimum value in 2nd column of month in first column

Published on 17 March 2024 at 13:19

score 30 · Answer 8 · 2024-03-15T13:35:45.807000

30

Views

ArrayFormula with SUMIFS not Working in Google Sheets

Published on 15 March 2024 at 13:35

score 43 · Answer 9 · 2024-03-15T03:32:28.737000

43

Views

Issue merging a SUMIFS using index Match into an arrayformula

Published on 15 March 2024 at 03:32

score 36 · Answer 10 · 2024-03-08T14:01:37.410000

36

Views

Filtering data by row Google sheets

Published on 08 March 2024 at 14:01

score 32 · Answer 11 · 2024-03-05T18:56:34.513000

32

Views

round sum_range of arrayformula

Published on 05 March 2024 at 18:56

score 29 · Answer 12 · 2024-03-04T07:27:10.360000

29

Views

Formula needed for column and row dependency

Published on 04 March 2024 at 07:27

score 99 · Answer 13 · 2024-02-29T13:44:04.580000

99

Views

Calculating percent error of each element of a list given a list of ratios

Published on 29 February 2024 at 13:44

score 110 · Answer 14 · 2024-02-20T22:03:41.660000

110

Views

Use Excel VBA Evaluate Method to Return/Analyze Moving Array At Every Row Over Range

Published on 20 February 2024 at 22:03

score 57 · Answer 15 · 2024-02-13T18:40:14.860000

57

Views

Google Sheets - Assign category based on list of search words

Published on 13 February 2024 at 18:40

score 57 · Answer 16 · 2024-02-12T03:57:25.097000

57

Views

Merge an array of concatenated columns in Excel

Published on 12 February 2024 at 03:57

score 50 · Answer 17 · 2024-02-11T21:58:40.983000

50

Views

Using one cell to sum multiple sets created by splitting one other cell (presumably using ARRAYFORMULA)

Published on 11 February 2024 at 21:58

score 39 · Answer 18 · 2024-02-10T21:20:11.470000

39

Views

Why my google sheets custom function doesn't work with arrayformula?

Published on 10 February 2024 at 21:20

score 33 · Answer 19 · 2024-02-10T21:05:07.390000

33

Views

In Google sheets, importing columns from another file using IMPORTRANGE. The inputted columns contain umlauts, causing problems when using ORDER BY

Published on 10 February 2024 at 21:05

score 44 · Answer 20 · 2024-02-08T07:41:10.597000

44

Views

Google Sheets Array Formula with Multiple Sequences of Varying Lengths, Starting Numbers, and Suffixes?

Published on 08 February 2024 at 07:41

List Question

Can I use Sumproduct arrays and check two separate criteria counting TRUE statements?

IF AND OR Nested ArrayFormula not working - What am I missing?

Return next not blank result based on a raw

Google Sheets: Return 1st, 2nd, 3rd, etc. instances of strings from range. Prepend values from top row to each string returned

Count duplicates if other cell contains week num google sheets

Waterfall value (get value from previous row to populate the next one) with arrayformula

Find minimum value in 2nd column of month in first column

ArrayFormula with SUMIFS not Working in Google Sheets

Issue merging a SUMIFS using index Match into an arrayformula

Filtering data by row Google sheets

round sum_range of arrayformula

Formula needed for column and row dependency

Calculating percent error of each element of a list given a list of ratios

Use Excel VBA Evaluate Method to Return/Analyze Moving Array At Every Row Over Range

Google Sheets - Assign category based on list of search words

Merge an array of concatenated columns in Excel

Using one cell to sum multiple sets created by splitting one other cell (presumably using ARRAYFORMULA)

Why my google sheets custom function doesn't work with arrayformula?

In Google sheets, importing columns from another file using IMPORTRANGE. The inputted columns contain umlauts, causing problems when using ORDER BY

Google Sheets Array Formula with Multiple Sequences of Varying Lengths, Starting Numbers, and Suffixes?

Trending Questions

Popular # Hahtags

Popular Questions