F G

4 $34.5
3 $ 23
1 $23
1 $34.5
1 $6.25
2 $23

How do I count the number of instances that are $34.5? The answer
should be 5 (Row 1= 4 * 34.5, and Row4 =1 * 34.5)

try this that must be array entered using ctrl+shift+enter
=COUNT(IF($O$2:$O$22=34.5,$O$2:$O$22))

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguillett1@austin.rr.com
"Paul" <Msr33@TPx12.com> wrote in message
news:i0p474579tqed31g089fnksdno319r6tg1@4ax.com...
>F G
>
> 4 $34.5
> 3 $ 23
> 1 $23
> 1 $34.5
> 1 $6.25
> 2 $23
>
> How do I count the number of instances that are $34.5? The answer
> should be 5 (Row 1= 4 * 34.5, and Row4 =1 * 34.5)
>

How about a simple:

=SUMIF(G1:G6,34.5,F1:F6)

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Paul" <Msr33@TPx12.com> wrote in message
news:i0p474579tqed31g089fnksdno319r6tg1@4ax.com...
>F G
>
> 4 $34.5
> 3 $ 23
> 1 $23
> 1 $34.5
> 1 $6.25
> 2 $23
>
> How do I count the number of instances that are $34.5? The answer
> should be 5 (Row 1= 4 * 34.5, and Row4 =1 * 34.5)
>

Thanks for both responses. I saved them. However the following
formula would only work if I reversed it

=SUMIF(F1:F6,34.5,G1:G6)

On Mon, 7 Jul 2008 12:32:47 -0700, "RagDyer" <ragdyer@cutoutmsn.com>
wrote:

>How about a simple:
>
>=SUMIF(G1:G6,34.5,F1:F6)

Thanks for the feed-back.

BTW - the formula I suggested matched the example in your OP.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Paul" <Msr33@TPx12.com> wrote in message
news:mat4749qr9fg7lh1c9otev6j3s29jftno9@4ax.com...
> Thanks for both responses. I saved them. However the following
> formula would only work if I reversed it
>
> =SUMIF(F1:F6,34.5,G1:G6)
>
> On Mon, 7 Jul 2008 12:32:47 -0700, "RagDyer" <ragdyer@cutoutmsn.com>
> wrote:
>
>>How about a simple:
>>
>>=SUMIF(G1:G6,34.5,F1:F6)
>