Calculation on lookup

[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

[Roger Govier]

Hi

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

--
Regards

Roger Govier


"sfi" <sfi@prysm.net> wrote in message
news:44030d17$0$32714$8b463f8a@news.nationwide.net...
> 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
>
>

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

"Roger Govier" wrote:

> Hi
>
> In cell A8
> = SUM(D1:D7)*COUNTIF(E1:E7,0.5625)
>
> --
> Regards
>
> Roger Govier
>
>
> "sfi" <sfi@prysm.net> wrote in message
> news:44030d17$0$32714$8b463f8a@news.nationwide.net...
> > 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
> >
> >
>
>
>

[Domenic]

Try...

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

Hope this helps!

In article <E7F4D73A-F37C-485C-8F5B-F3E6F27BB2B9@microsoft.com>,
"DuWayne" <DuWayne@discussions.microsoft.com> 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" <sfi@prysm.net> wrote in message
> > news:44030d17$0$32714$8b463f8a@news.nationwide.net...
> > > 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
> > >
> > >
> >
> >
> >

[Roger Govier]

Hi
Sorry, I totally misread your question.

Domenic has given you the solution though.

--
Regards

Roger Govier


"DuWayne" <DuWayne@discussions.microsoft.com> wrote in message
news:E7F4D73A-F37C-485C-8F5B-F3E6F27BB2B9@microsoft.com...
> = 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" <sfi@prysm.net> wrote in message
>> news:44030d17$0$32714$8b463f8a@news.nationwide.net...
>> > 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
>> >
>> >
>>
>>
>>