Search code examples
arraysgoogle-sheetsfiltersumgoogle-query-language

Trying to combine the sums of a filter into one cell


=filter(K24:K29,H24:H29="buy") / filter(I24:I29,H24:H29="buy")

Currently it outputs multiple matches separately like below:

               (1000)  /  (100)
               (400)   /  (100)

I would like to combine the sums into one cell like this:

               (1400)  /  (200)

I thought =SUMIF would do it but getting errors.


Solution

  • try:

    ={SUM(FILTER(K24:K29, H24:H29="buy")), SUM(FILTER(I24:I29, H24:H29="buy"))}