Calculation on lookup

S

sfi

How do I count how many ".5625" 's there are in column E and multiply the
count by the quantity in column D and put the total in A8?


A B C D E
1
2
3
4 4 .5625
5 1 .750
6 3 .625
7 2 .5625
8 6


Thanks
DuWayne
 
D

DuWayne

= SUM(D1:D7)*COUNTIF(E1:E7,0.5625)

This formula calculates the entire column of D which is 10
I need it to count each 0.5625 in column E and add the totals of
column D next to each 0.5625 and put answer in cell A8?
The correct answer should be 6.
 
R

Roger Govier

Hi
Sorry, I totally misread your question.

Domenic has given you the solution though.
 
Top