Need Help on formula

[Guest]

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

 

[Sandy Mann]

=SUMPRODUCT((C2:C6="Apple")*(D26))

--
HTH

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

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk

 

[Guest]

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

=SUMPRODUCT((C2:C6="Apple")*(D26))

--
HTH

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

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk

 

[Dave Peterson]

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.

 

[Sandy Mann]

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

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk

 

[Guest]

Thanks Dave that helps.

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.

 

[Sandy Mann]

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

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk

 

[Dave Peterson]

Been there too often.

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

--

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

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk