Using single criteria and SumIf with multiple columns

0
votes

Found an easy work around to dynamically iterate down a column and add up values for a single criteria. Looking to expand the formula to work with the same single criteria, but add two columns NOT adjacent to each other:

=SUMIF(A:A,A2,L:L)

Criteria in Column A, want to sum column L AND column S. Criteria is a text field.

1
excelexcel-formula
Use a =SUMIFS or =SUMPRODUCT then. - ian0411
what column do you want to SUM ? - PeterH

1 Answers

1
votes
=SUMIF(A:A,A2,L:L)+SUMIF(A:A,A2,S:S)

is the only way I know of achieving this without creating extra cells

You can also create a new column that is the sum of L and S and sum on this column