Calculation on lookup
 

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

Calculation on lookup
 

Hi

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

--
Regards

Roger Govier


"sfi" wrote in message
...
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

Calculation on lookup
 

= 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.

"Roger Govier" wrote:

Hi

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

--
Regards

Roger Govier


"sfi" wrote in message
...
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

Calculation on lookup
 

Try...

=SUMIF(E4:E7,0.5625,D4:D7)

Hope this helps!

In article ,
"DuWayne" wrote:

= 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.

"Roger Govier" wrote:

Hi

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

--
Regards

Roger Govier


"sfi" wrote in message
...
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

Calculation on lookup
 

Hi
Sorry, I totally misread your question.

Domenic has given you the solution though.

--
Regards

Roger Govier


"DuWayne" wrote in message
...
= 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.

"Roger Govier" wrote:

Hi

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

--
Regards

Roger Govier


"sfi" wrote in message
...
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