SumProduct

[HeatherMichelle]

I am trying to creat a roll up sheet. on my data sheet I have multiple
columns of data.

F K L R
51160 2 6 3
51160 1 4 1
51162 0 5 2
51162 1 0 3

I am trying to create a formula that will search column F for matching
numbers and then add all cooresponding data in column K, L, and R. So cell A1
of my roll up sheet for "51160" will show the total of 17... Any ideas? Thanks

 

[Jacob Skaria]

Try
=SUM(SUMIF(F1:F10,51160,INDIRECT({"K1:K10","L1:L10","R1:R10"})))

 

[T. Valko]

Try this...

=SUMPRODUCT(--(F2:F10=51160),K2:K10+L2:L10+R2:R10)