Count, numbers and text
 

I have data in rows 3 to 49 and columns A to U. In column L are names of
destinations. In Column K are weights delivered to those destinations. I need
a formula to give me the total weight delivered to each of those
destinations. Can anyone help please?!

Count, numbers and text
 

Hi Mel

Try putting a list of the destinations you need to total in say cells
W1:W10 then in cell X1 enter
=SUMIF(K:K,W1,L:L)
Copy formula down through cells X2:X10

Make the range in W long enough to deal with each of your required
locations


--
Regards

Roger Govier


"Mel" wrote in message
...
I have data in rows 3 to 49 and columns A to U. In column L are names
of
destinations. In Column K are weights delivered to those destinations.
I need
a formula to give me the total weight delivered to each of those
destinations. Can anyone help please?!

Count, numbers and text
 

Hi Roger - thanks but it didn't work, returned a 0. I put my in destinations
in H53 to H61 and used the rest of your formula. Any other ideas?

"Roger Govier" wrote:

Hi Mel

Try putting a list of the destinations you need to total in say cells
W1:W10 then in cell X1 enter
=SUMIF(K:K,W1,L:L)
Copy formula down through cells X2:X10

Make the range in W long enough to deal with each of your required
locations


--
Regards

Roger Govier


"Mel" wrote in message
...
I have data in rows 3 to 49 and columns A to U. In column L are names
of
destinations. In Column K are weights delivered to those destinations.
I need
a formula to give me the total weight delivered to each of those
destinations. Can anyone help please?!

Count, numbers and text
 

Hi Mel,

try to use:

sumproduct((K2:k100=h53)*(L2:l100))

does this help?
regards from Brazil
Marcelo


"Mel" escreveu:

Hi Roger - thanks but it didn't work, returned a 0. I put my in destinations
in H53 to H61 and used the rest of your formula. Any other ideas?

"Roger Govier" wrote:

Hi Mel

Try putting a list of the destinations you need to total in say cells
W1:W10 then in cell X1 enter
=SUMIF(K:K,W1,L:L)
Copy formula down through cells X2:X10

Make the range in W long enough to deal with each of your required
locations


--
Regards

Roger Govier


"Mel" wrote in message
...
I have data in rows 3 to 49 and columns A to U. In column L are names
of
destinations. In Column K are weights delivered to those destinations.
I need
a formula to give me the total weight delivered to each of those
destinations. Can anyone help please?!

Count, numbers and text
 

Hi Marcelo - Thanks, this is driving me nuts! This is my table/summary. The
first destination Chililabombwe is in H53 in the summary. The data for all
the destinations is in column L3 to L49 in the worksheet. The weights are in
column K3 to K49. Deliveries are made throughout the month and vary. When I
used your formula I got the #VALUE error message?(There are more destinations
than this!)

DESTINATION WEIGHT
Chililabombwe #VALUE!
Kabwe #VALUE!
Kasama #VALUE!
Kitwe #VALUE!

"Marcelo" wrote:

Hi Mel,

try to use:

sumproduct((K2:k100=h53)*(L2:l100))

does this help?
regards from Brazil
Marcelo


"Mel" escreveu:

Hi Roger - thanks but it didn't work, returned a 0. I put my in destinations
in H53 to H61 and used the rest of your formula. Any other ideas?

"Roger Govier" wrote:

Hi Mel

Try putting a list of the destinations you need to total in say cells
W1:W10 then in cell X1 enter
=SUMIF(K:K,W1,L:L)
Copy formula down through cells X2:X10

Make the range in W long enough to deal with each of your required
locations


--
Regards

Roger Govier


"Mel" wrote in message
...
I have data in rows 3 to 49 and columns A to U. In column L are names
of
destinations. In Column K are weights delivered to those destinations.
I need
a formula to give me the total weight delivered to each of those
destinations. Can anyone help please?!

Count, numbers and text
 

The K Column (Weights) are text?

regards

"Mel" escreveu:

Hi Marcelo - Thanks, this is driving me nuts! This is my table/summary. The
first destination Chililabombwe is in H53 in the summary. The data for all
the destinations is in column L3 to L49 in the worksheet. The weights are in
column K3 to K49. Deliveries are made throughout the month and vary. When I
used your formula I got the #VALUE error message?(There are more destinations
than this!)

DESTINATION WEIGHT
Chililabombwe #VALUE!
Kabwe #VALUE!
Kasama #VALUE!
Kitwe #VALUE!

"Marcelo" wrote:

Hi Mel,

try to use:

sumproduct((K2:k100=h53)*(L2:l100))

does this help?
regards from Brazil
Marcelo


"Mel" escreveu:

Hi Roger - thanks but it didn't work, returned a 0. I put my in destinations
in H53 to H61 and used the rest of your formula. Any other ideas?

"Roger Govier" wrote:

Hi Mel

Try putting a list of the destinations you need to total in say cells
W1:W10 then in cell X1 enter
=SUMIF(K:K,W1,L:L)
Copy formula down through cells X2:X10

Make the range in W long enough to deal with each of your required
locations


--
Regards

Roger Govier


"Mel" wrote in message
...
I have data in rows 3 to 49 and columns A to U. In column L are names
of
destinations. In Column K are weights delivered to those destinations.
I need
a formula to give me the total weight delivered to each of those
destinations. Can anyone help please?!

Count, numbers and text
 

No - destination is text weight is figures i.e. 28

"Marcelo" wrote:

The K Column (Weights) are text?

regards

"Mel" escreveu:

Hi Marcelo - Thanks, this is driving me nuts! This is my table/summary. The
first destination Chililabombwe is in H53 in the summary. The data for all
the destinations is in column L3 to L49 in the worksheet. The weights are in
column K3 to K49. Deliveries are made throughout the month and vary. When I
used your formula I got the #VALUE error message?(There are more destinations
than this!)

DESTINATION WEIGHT
Chililabombwe #VALUE!
Kabwe #VALUE!
Kasama #VALUE!
Kitwe #VALUE!

"Marcelo" wrote:

Hi Mel,

try to use:

sumproduct((K2:k100=h53)*(L2:l100))

does this help?
regards from Brazil
Marcelo


"Mel" escreveu:

Hi Roger - thanks but it didn't work, returned a 0. I put my in destinations
in H53 to H61 and used the rest of your formula. Any other ideas?

"Roger Govier" wrote:

Hi Mel

Try putting a list of the destinations you need to total in say cells
W1:W10 then in cell X1 enter
=SUMIF(K:K,W1,L:L)
Copy formula down through cells X2:X10

Make the range in W long enough to deal with each of your required
locations


--
Regards

Roger Govier


"Mel" wrote in message
...
I have data in rows 3 to 49 and columns A to U. In column L are names
of
destinations. In Column K are weights delivered to those destinations.
I need
a formula to give me the total weight delivered to each of those
destinations. Can anyone help please?!

Count, numbers and text
 

so the formula should work.

Try,
=sumproduct(($L$3:$L$49=H53)*($K$3:$K$49))

Hope this helps
Regards from Brazil
Marcelo



"Mel" escreveu:

No - destination is text weight is figures i.e. 28

"Marcelo" wrote:

The K Column (Weights) are text?

regards

"Mel" escreveu:

Hi Marcelo - Thanks, this is driving me nuts! This is my table/summary. The
first destination Chililabombwe is in H53 in the summary. The data for all
the destinations is in column L3 to L49 in the worksheet. The weights are in
column K3 to K49. Deliveries are made throughout the month and vary. When I
used your formula I got the #VALUE error message?(There are more destinations
than this!)

DESTINATION WEIGHT
Chililabombwe #VALUE!
Kabwe #VALUE!
Kasama #VALUE!
Kitwe #VALUE!

"Marcelo" wrote:

Hi Mel,

try to use:

sumproduct((K2:k100=h53)*(L2:l100))

does this help?
regards from Brazil
Marcelo


"Mel" escreveu:

Hi Roger - thanks but it didn't work, returned a 0. I put my in destinations
in H53 to H61 and used the rest of your formula. Any other ideas?

"Roger Govier" wrote:

Hi Mel

Try putting a list of the destinations you need to total in say cells
W1:W10 then in cell X1 enter
=SUMIF(K:K,W1,L:L)
Copy formula down through cells X2:X10

Make the range in W long enough to deal with each of your required
locations


--
Regards

Roger Govier


"Mel" wrote in message
...
I have data in rows 3 to 49 and columns A to U. In column L are names
of
destinations. In Column K are weights delivered to those destinations.
I need
a formula to give me the total weight delivered to each of those
destinations. Can anyone help please?!

Count, numbers and text
 

You're my hero! Thanks a bunch. What are $'s? they were obviously the trick!

"Marcelo" wrote:

so the formula should work.

Try,
=sumproduct(($L$3:$L$49=H53)*($K$3:$K$49))

Hope this helps
Regards from Brazil
Marcelo



"Mel" escreveu:

No - destination is text weight is figures i.e. 28

"Marcelo" wrote:

The K Column (Weights) are text?

regards

"Mel" escreveu:

Hi Marcelo - Thanks, this is driving me nuts! This is my table/summary. The
first destination Chililabombwe is in H53 in the summary. The data for all
the destinations is in column L3 to L49 in the worksheet. The weights are in
column K3 to K49. Deliveries are made throughout the month and vary. When I
used your formula I got the #VALUE error message?(There are more destinations
than this!)

DESTINATION WEIGHT
Chililabombwe #VALUE!
Kabwe #VALUE!
Kasama #VALUE!
Kitwe #VALUE!

"Marcelo" wrote:

Hi Mel,

try to use:

sumproduct((K2:k100=h53)*(L2:l100))

does this help?
regards from Brazil
Marcelo


"Mel" escreveu:

Hi Roger - thanks but it didn't work, returned a 0. I put my in destinations
in H53 to H61 and used the rest of your formula. Any other ideas?

"Roger Govier" wrote:

Hi Mel

Try putting a list of the destinations you need to total in say cells
W1:W10 then in cell X1 enter
=SUMIF(K:K,W1,L:L)
Copy formula down through cells X2:X10

Make the range in W long enough to deal with each of your required
locations


--
Regards

Roger Govier


"Mel" wrote in message
...
I have data in rows 3 to 49 and columns A to U. In column L are names
of
destinations. In Column K are weights delivered to those destinations.
I need
a formula to give me the total weight delivered to each of those
destinations. Can anyone help please?!