0

I have an array table using ARRAYFORMULA({Fruit Names, Quantity}) that looks like

| Apples  |  2 |
| Oranges |  3 |
| Bananas |  5 |
| Oranges | -2 |
| Bananas | -1 |
| Apples  |  1 |

I'd like to sum all the unique items into one list into:

| Apples  |  3 |
| Oranges |  1 |
| Bananas |  4 |

Without referencing specific cells (I populated the arrayformula from other data). Any way to do this without referencing cells and using only arrayformula?

1

Found the solution with

Query(ARRAYFORMULA, "select Col1, sum(Col2) where Col1<>'' group by Col1")

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.