R
Rick Melton
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
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
10)