Simple formula help please?

[office]

If the number "2" appears in column D and any two numbers are the same in
column B I'm trying to get it to sum column E.
I want excel to ignore the figures in column E that don't have a "2" in
column D. e.g.


col B col D colE
3456 2 3.25
3456 2 2.00
3456 0 16.50
7654 0 23.00
3456 2 2.00
7654 0 17.75
7654 2 1.25
4321 2 43.50
4321 0 32.00

So my total for 3456 would be 7.25.

Any help would really be appreciated
Thanx in advance
Rick

 

[Jerry W. Lewis]

=SUMPRODUCT((B1:B10=3456)*(D110=2),E1:E10)
gets your 7.25 total

=SUMPRODUCT((B1:B10=3456)*(D110=2))
tells you that 3 numbers were summed to get it.

Jerry

 

[Nicole]

I dont know too much about excel, but have you tried using IF statments?