google sheets
I have a sheet that I am using the filter formula to find and display multiple values. This works great for displaying the results in a vertical column, where the values are pasted down in the column below the formula.
However, I would like to display the results in a comma separated list in one cell (or alternatively, pasted horizontally). Is there an alternate formula I should be using, or some formula to transpose the vertical results?
In order to reproduce the result, given by the OP, you need to use this formula.
=SUM(FILTER(C2:C,B2:B=D6,A2:A>=D4,A2:A<=D5))
Apart from that, you need to change the end date from 7/20/2012 to 7/23/2012
See example file I prepared: SUM with FILTER
In Google Sheets, when you copy a formula that uses relative references to another cell, that references are automatically updated.
If in cell B2 the formula is =A2 and you copy it and paste to cell B43, the resulting formula will be =A43.
If in cell B2 the formula is
=HYPERLINK(CONCATENATE("http://example.com?id=",A2),A2)
and you copy it and paste to cell B455, the resulting formula will be
=HYPERLINK(CONCATENATE("http://example.com?id=",A455),A455).
References
Add formulas to a spreadsheet - Docs editors help
Best Answer
If it's just a single column of results, you could use JOIN:
Alternatively, You could also use