Is it possible to write a sum-formula in Google Sheet that would add together all the values in the E-column which number in the F-column for example is "2"?

Visual example

Hope the question makes sense,

CodePudding user response：

solution #1

Make a pivot table

solution #2

=QUERY(E2:F,"select F,sum(E) where F is not null group by F  ")