SumProduct
 

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

SumProduct
 

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

--
Jacob


"HeatherMichelle" wrote:

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

SumProduct
 

Try this...

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

--
Biff
Microsoft Excel MVP


"HeatherMichelle" wrote in
message ...
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