Have list of column of type of products in C and Total of pounds in D, in
cell F3 how do you add up total pounds if E is type of products in column D
if Column C have same products?

A B C D E F
1 Apple 500
2 Orange 200
3 Cherry 100 Apple 800
4 Apple 300 Cherry 250
5 Cherry 150
6

=SUMPRODUCT((C2:C6="Apple")*(D2:D6))

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"Curtis" wrote in message
...
Have list of column of type of products in C and Total of pounds in D, in
cell F3 how do you add up total pounds if E is type of products in column
D
if Column C have same products?

A B C D E F
1 Apple 500
2 Orange 200
3 Cherry 100 Apple 800
4 Apple 300 Cherry 250
5 Cherry 150
6

I have try that, it gives me a value error?

"Sandy Mann" wrote:

=SUMPRODUCT((C2:C6="Apple")*(D2:D6))

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"Curtis" wrote in message
...
Have list of column of type of products in C and Total of pounds in D, in
cell F3 how do you add up total pounds if E is type of products in column
D
if Column C have same products?

A B C D E F
1 Apple 500
2 Orange 200
3 Cherry 100 Apple 800
4 Apple 300 Cherry 250
5 Cherry 150
6

In F3:
=sumif(c:c,e3,d:d)

If I read the columns/rows correctly.

Column C containd the list of fruit. Column D contained the values. E3
contained Apple.

Curtis wrote:

Have list of column of type of products in C and Total of pounds in D, in
cell F3 how do you add up total pounds if E is type of products in column D
if Column C have same products?

A B C D E F
1 Apple 500
2 Orange 200
3 Cherry 100 Apple 800
4 Apple 300 Cherry 250
5 Cherry 150
6

--

Dave Peterson

Hi Curtis,

It sounds like there is a problem with your data in Column D. Did you
download the data from the 'net by chance? Often when people do that there
are axtra non-printing charaters at the start or end of the seen data.

Try typing out the data that you originally posted in a new spreadsheet, if
that works then the problem must lie with you original data.

Try highlighting the original data in Column D and then select Edir
Replace and in the "Find what:" box enter 0160 from the number pad NOT the
numbers above the letter keys. Leave the "Replace with:" box empty and
click on Repalce all. This should remove all the non-breaking spaces in the
data and the formula works for me even with spaces both before and after the
data.

Post back if you still have trouble.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"Curtis" wrote in message
...
I have try that, it gives me a value error?

"Sandy Mann" wrote:

=SUMPRODUCT((C2:C6="Apple")*(D2:D6))

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"Curtis" wrote in message
...
Have list of column of type of products in C and Total of pounds in D,
in
cell F3 how do you add up total pounds if E is type of products in
column
D
if Column C have same products?

A B C D E F
1 Apple 500
2 Orange 200
3 Cherry 100 Apple 800
4 Apple 300 Cherry 250
5 Cherry 150
6

Thanks Dave that helps.

"Dave Peterson" wrote:

In F3:
=sumif(c:c,e3,d:d)

If I read the columns/rows correctly.

Column C containd the list of fruit. Column D contained the values. E3
contained Apple.

Curtis wrote:

Have list of column of type of products in C and Total of pounds in D, in
cell F3 how do you add up total pounds if E is type of products in column D
if Column C have same products?

A B C D E F
1 Apple 500
2 Orange 200
3 Cherry 100 Apple 800
4 Apple 300 Cherry 250
5 Cherry 150
6

--

Dave Peterson

"Dave Peterson" wrote:

In F3:
=sumif(c:c,e3,d:d)

I've gone *SUMPRODUCT()* happy <g

--

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk

Been there too often.

Sandy Mann wrote:

"Dave Peterson" wrote:

In F3:
=sumif(c:c,e3,d:d)

I've gone *SUMPRODUCT()* happy <g

--

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk

--

Dave Peterson