software

How do I count how many quot;.5625quot; '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 6Thanks
DuWayne
Hi

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

--
Regards

Roger Govierquot;sfiquot; gt; wrote in message ...
gt; How do I count how many quot;.5625quot; 's there are in column E and multiply
gt; the
gt; count by the quantity in column D and put the total in A8?
gt;
gt;
gt; A B C D E
gt; 1
gt; 2
gt; 3
gt; 4 4 .5625
gt; 5 1 .750
gt; 6 3 .625
gt; 7 2 .5625
gt; 8 6
gt;
gt;
gt; Thanks
gt; DuWayne
gt;
gt;
= SUM(D17)*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.

quot;Roger Govierquot; wrote:

gt; Hi
gt;
gt; In cell A8
gt; = SUM(D17)*COUNTIF(E1:E7,0.5625)
gt;
gt; --
gt; Regards
gt;
gt; Roger Govier
gt;
gt;
gt; quot;sfiquot; gt; wrote in message
gt; ...
gt; gt; How do I count how many quot;.5625quot; 's there are in column E and multiply
gt; gt; the
gt; gt; count by the quantity in column D and put the total in A8?
gt; gt;
gt; gt;
gt; gt; A B C D E
gt; gt; 1
gt; gt; 2
gt; gt; 3
gt; gt; 4 4 .5625
gt; gt; 5 1 .750
gt; gt; 6 3 .625
gt; gt; 7 2 .5625
gt; gt; 8 6
gt; gt;
gt; gt;
gt; gt; Thanks
gt; gt; DuWayne
gt; gt;
gt; gt;
gt;
gt;
gt;

Try...

=SUMIF(E4:E7,0.5625,D47)

Hope this helps!

In article gt;,
quot;DuWaynequot; gt; wrote:

gt; = SUM(D17)*COUNTIF(E1:E7,0.5625)
gt;
gt; This formula calculates the entire column of D which is 10
gt; I need it to count each 0.5625 in column E and add the totals of
gt; column D next to each 0.5625 and put answer in cell A8?
gt; The correct answer should be 6.
gt;
gt; quot;Roger Govierquot; wrote:
gt;
gt; gt; Hi
gt; gt;
gt; gt; In cell A8
gt; gt; = SUM(D17)*COUNTIF(E1:E7,0.5625)
gt; gt;
gt; gt; --
gt; gt; Regards
gt; gt;
gt; gt; Roger Govier
gt; gt;
gt; gt;
gt; gt; quot;sfiquot; gt; wrote in message
gt; gt; ...
gt; gt; gt; How do I count how many quot;.5625quot; 's there are in column E and multiply
gt; gt; gt; the
gt; gt; gt; count by the quantity in column D and put the total in A8?
gt; gt; gt;
gt; gt; gt;
gt; gt; gt; A B C D E
gt; gt; gt; 1
gt; gt; gt; 2
gt; gt; gt; 3
gt; gt; gt; 4 4 .5625
gt; gt; gt; 5 1 .750
gt; gt; gt; 6 3 .625
gt; gt; gt; 7 2 .5625
gt; gt; gt; 8 6
gt; gt; gt;
gt; gt; gt;
gt; gt; gt; Thanks
gt; gt; gt; DuWayne
gt; gt; gt;
gt; gt; gt;
gt; gt;
gt; gt;
gt; gt;

Hi
Sorry, I totally misread your question.

Domenic has given you the solution though.

--
Regards

Roger Govierquot;DuWaynequot; gt; wrote in message
...
gt; = SUM(D17)*COUNTIF(E1:E7,0.5625)
gt;
gt; This formula calculates the entire column of D which is 10
gt; I need it to count each 0.5625 in column E and add the totals of
gt; column D next to each 0.5625 and put answer in cell A8?
gt; The correct answer should be 6.
gt;
gt; quot;Roger Govierquot; wrote:
gt;
gt;gt; Hi
gt;gt;
gt;gt; In cell A8
gt;gt; = SUM(D17)*COUNTIF(E1:E7,0.5625)
gt;gt;
gt;gt; --
gt;gt; Regards
gt;gt;
gt;gt; Roger Govier
gt;gt;
gt;gt;
gt;gt; quot;sfiquot; gt; wrote in message
gt;gt; ...
gt;gt; gt; How do I count how many quot;.5625quot; 's there are in column E and
gt;gt; gt; multiply
gt;gt; gt; the
gt;gt; gt; count by the quantity in column D and put the total in A8?
gt;gt; gt;
gt;gt; gt;
gt;gt; gt; A B C D E
gt;gt; gt; 1
gt;gt; gt; 2
gt;gt; gt; 3
gt;gt; gt; 4 4 .5625
gt;gt; gt; 5 1 .750
gt;gt; gt; 6 3 .625
gt;gt; gt; 7 2 .5625
gt;gt; gt; 8 6
gt;gt; gt;
gt;gt; gt;
gt;gt; gt; Thanks
gt;gt; gt; DuWayne
gt;gt; gt;
gt;gt; gt;
gt;gt;
gt;gt;
gt;gt;