I have a column which I am trying to get the number of occurrances of "9" for
example. The "9" is a formula of two functions 1) VLOOKUP in another column
and 2) SUM of various VLOOKUP columns. I can't get COUNTIF to work on either
of these columns. I think it doesn't like SUM because it is a result of
VLOOKUP columns.

What is (are) your formula(e)?

"VettRacer" wrote:

> I have a column which I am trying to get the number of occurrances of "9" for
> example. The "9" is a formula of two functions 1) VLOOKUP in another column
> and 2) SUM of various VLOOKUP columns. I can't get COUNTIF to work on either
> of these columns. I think it doesn't like SUM because it is a result of
> VLOOKUP columns.

=SUM(G51+J51+L51+N51+P51)/5 this is a result of various similar formulas

=VLOOKUP(O51,$V$7:$W$18,2)

"Toppers" wrote:

> What is (are) your formula(e)?
>
> "VettRacer" wrote:
>
> > I have a column which I am trying to get the number of occurrances of "9" for
> > example. The "9" is a formula of two functions 1) VLOOKUP in another column
> > and 2) SUM of various VLOOKUP columns. I can't get COUNTIF to work on either
> > of these columns. I think it doesn't like SUM because it is a result of
> > VLOOKUP columns.

Shouldn't you post the formula that didn't work?


--
Regards,

Peo Sjoblom



"VettRacer" <(E-Mail Removed)> wrote in message
news:F13DAAB2-EFFE-4E3E-944A-(E-Mail Removed)...
> =SUM(G51+J51+L51+N51+P51)/5 this is a result of various similar formulas
>
> =VLOOKUP(O51,$V$7:$W$18,2)
>
> "Toppers" wrote:
>
>> What is (are) your formula(e)?
>>
>> "VettRacer" wrote:
>>
>> > I have a column which I am trying to get the number of occurrances of
>> > "9" for
>> > example. The "9" is a formula of two functions 1) VLOOKUP in another
>> > column
>> > and 2) SUM of various VLOOKUP columns. I can't get COUNTIF to work on
>> > either
>> > of these columns. I think it doesn't like SUM because it is a result
>> > of
>> > VLOOKUP columns.

When you say COUNTIF doesn't work, what results do you get? And your COUNTIF
formula is ..?

The fact the a value is derived from a formula shouldn't make any
difference? Do you always have valid values in the column(s) you are checking?

"VettRacer" wrote:

> =SUM(G51+J51+L51+N51+P51)/5 this is a result of various similar formulas
>
> =VLOOKUP(O51,$V$7:$W$18,2)
>
> "Toppers" wrote:
>
> > What is (are) your formula(e)?
> >
> > "VettRacer" wrote:
> >
> > > I have a column which I am trying to get the number of occurrances of "9" for
> > > example. The "9" is a formula of two functions 1) VLOOKUP in another column
> > > and 2) SUM of various VLOOKUP columns. I can't get COUNTIF to work on either
> > > of these columns. I think it doesn't like SUM because it is a result of
> > > VLOOKUP columns.

=COUNTIF(Q51:Q56,9)
"Peo Sjoblom" wrote:

> Shouldn't you post the formula that didn't work?
>
>
> --
> Regards,
>
> Peo Sjoblom
>
>
>
> "VettRacer" <(E-Mail Removed)> wrote in message
> news:F13DAAB2-EFFE-4E3E-944A-(E-Mail Removed)...
> > =SUM(G51+J51+L51+N51+P51)/5 this is a result of various similar formulas
> >
> > =VLOOKUP(O51,$V$7:$W$18,2)
> >
> > "Toppers" wrote:
> >
> >> What is (are) your formula(e)?
> >>
> >> "VettRacer" wrote:
> >>
> >> > I have a column which I am trying to get the number of occurrances of
> >> > "9" for
> >> > example. The "9" is a formula of two functions 1) VLOOKUP in another
> >> > column
> >> > and 2) SUM of various VLOOKUP columns. I can't get COUNTIF to work on
> >> > either
> >> > of these columns. I think it doesn't like SUM because it is a result
> >> > of
> >> > VLOOKUP columns.
>
>
>

Sorry--here's the formula.
=COUNTIF('OPRS Conv Tracker'!Q51:Q200,9)
Which refers to the SUM formula mentioned which that refers to the VLOOKUP.
Even when I've changed it so it doesn't reference a another worksheet, it
still doesn't work.

"Toppers" wrote:

> When you say COUNTIF doesn't work, what results do you get? And your COUNTIF
> formula is ..?
>
> The fact the a value is derived from a formula shouldn't make any
> difference? Do you always have valid values in the column(s) you are checking?
>
> "VettRacer" wrote:
>
> > =SUM(G51+J51+L51+N51+P51)/5 this is a result of various similar formulas
> >
> > =VLOOKUP(O51,$V$7:$W$18,2)
> >
> > "Toppers" wrote:
> >
> > > What is (are) your formula(e)?
> > >
> > > "VettRacer" wrote:
> > >
> > > > I have a column which I am trying to get the number of occurrances of "9" for
> > > > example. The "9" is a formula of two functions 1) VLOOKUP in another column
> > > > and 2) SUM of various VLOOKUP columns. I can't get COUNTIF to work on either
> > > > of these columns. I think it doesn't like SUM because it is a result of
> > > > VLOOKUP columns.

When you say it is not working, do you mean you get an unexpected result or
do you get an error message?


--
Regards,

Peo Sjoblom


"VettRacer" <(E-Mail Removed)> wrote in message
news:2CC46E59-D2F9-40C6-B5C1-(E-Mail Removed)...
> Sorry--here's the formula.
> =COUNTIF('OPRS Conv Tracker'!Q51:Q200,9)
> Which refers to the SUM formula mentioned which that refers to the
> VLOOKUP.
> Even when I've changed it so it doesn't reference a another worksheet, it
> still doesn't work.
>
> "Toppers" wrote:
>
>> When you say COUNTIF doesn't work, what results do you get? And your
>> COUNTIF
>> formula is ..?
>>
>> The fact the a value is derived from a formula shouldn't make any
>> difference? Do you always have valid values in the column(s) you are
>> checking?
>>
>> "VettRacer" wrote:
>>
>> > =SUM(G51+J51+L51+N51+P51)/5 this is a result of various similar
>> > formulas
>> >
>> > =VLOOKUP(O51,$V$7:$W$18,2)
>> >
>> > "Toppers" wrote:
>> >
>> > > What is (are) your formula(e)?
>> > >
>> > > "VettRacer" wrote:
>> > >
>> > > > I have a column which I am trying to get the number of occurrances
>> > > > of "9" for
>> > > > example. The "9" is a formula of two functions 1) VLOOKUP in
>> > > > another column
>> > > > and 2) SUM of various VLOOKUP columns. I can't get COUNTIF to work
>> > > > on either
>> > > > of these columns. I think it doesn't like SUM because it is a
>> > > > result of
>> > > > VLOOKUP columns.

I get an unexpected result: an incorrect number.

"Peo Sjoblom" wrote:

> When you say it is not working, do you mean you get an unexpected result or
> do you get an error message?
>
>
> --
> Regards,
>
> Peo Sjoblom
>
>
> "VettRacer" <(E-Mail Removed)> wrote in message
> news:2CC46E59-D2F9-40C6-B5C1-(E-Mail Removed)...
> > Sorry--here's the formula.
> > =COUNTIF('OPRS Conv Tracker'!Q51:Q200,9)
> > Which refers to the SUM formula mentioned which that refers to the
> > VLOOKUP.
> > Even when I've changed it so it doesn't reference a another worksheet, it
> > still doesn't work.
> >
> > "Toppers" wrote:
> >
> >> When you say COUNTIF doesn't work, what results do you get? And your
> >> COUNTIF
> >> formula is ..?
> >>
> >> The fact the a value is derived from a formula shouldn't make any
> >> difference? Do you always have valid values in the column(s) you are
> >> checking?
> >>
> >> "VettRacer" wrote:
> >>
> >> > =SUM(G51+J51+L51+N51+P51)/5 this is a result of various similar
> >> > formulas
> >> >
> >> > =VLOOKUP(O51,$V$7:$W$18,2)
> >> >
> >> > "Toppers" wrote:
> >> >
> >> > > What is (are) your formula(e)?
> >> > >
> >> > > "VettRacer" wrote:
> >> > >
> >> > > > I have a column which I am trying to get the number of occurrances
> >> > > > of "9" for
> >> > > > example. The "9" is a formula of two functions 1) VLOOKUP in
> >> > > > another column
> >> > > > and 2) SUM of various VLOOKUP columns. I can't get COUNTIF to work
> >> > > > on either
> >> > > > of these columns. I think it doesn't like SUM because it is a
> >> > > > result of
> >> > > > VLOOKUP columns.
>
>
>

Does it work if you use the column/range where the VLOOKUP pulls from?

My guess is that you somehow are not using the correct sheet/range or that
the values are not integers but that they have decimals as well

You can also try


=COUNTIF('OPRS Conv Tracker'!Q51:Q200,"*9*")

Shouldn't really matter and this is just to test if you will get anything at
all..


Try this, select part of the range that you know has a 9, copy it to a new
sheet and paste special as values, wide the column if necessary and if you
see things like

9,000000001

then that is the reason, if so you might want to use round in the
vlookup/sum formulas

You can also try it in the new sheet, if you paste then as values into
A1:A100 or something use

=COUNTIF(A1:A100,9)

--
Regards,

Peo Sjoblom






"VettRacer" <(E-Mail Removed)> wrote in message
news:ED965B92-D8D5-4FE4-9A19-(E-Mail Removed)...
>I get an unexpected result: an incorrect number.
>
> "Peo Sjoblom" wrote:
>
>> When you say it is not working, do you mean you get an unexpected result
>> or
>> do you get an error message?
>>
>>
>> --
>> Regards,
>>
>> Peo Sjoblom
>>
>>
>> "VettRacer" <(E-Mail Removed)> wrote in message
>> news:2CC46E59-D2F9-40C6-B5C1-(E-Mail Removed)...
>> > Sorry--here's the formula.
>> > =COUNTIF('OPRS Conv Tracker'!Q51:Q200,9)
>> > Which refers to the SUM formula mentioned which that refers to the
>> > VLOOKUP.
>> > Even when I've changed it so it doesn't reference a another worksheet,
>> > it
>> > still doesn't work.
>> >
>> > "Toppers" wrote:
>> >
>> >> When you say COUNTIF doesn't work, what results do you get? And your
>> >> COUNTIF
>> >> formula is ..?
>> >>
>> >> The fact the a value is derived from a formula shouldn't make any
>> >> difference? Do you always have valid values in the column(s) you are
>> >> checking?
>> >>
>> >> "VettRacer" wrote:
>> >>
>> >> > =SUM(G51+J51+L51+N51+P51)/5 this is a result of various similar
>> >> > formulas
>> >> >
>> >> > =VLOOKUP(O51,$V$7:$W$18,2)
>> >> >
>> >> > "Toppers" wrote:
>> >> >
>> >> > > What is (are) your formula(e)?
>> >> > >
>> >> > > "VettRacer" wrote:
>> >> > >
>> >> > > > I have a column which I am trying to get the number of
>> >> > > > occurrances
>> >> > > > of "9" for
>> >> > > > example. The "9" is a formula of two functions 1) VLOOKUP in
>> >> > > > another column
>> >> > > > and 2) SUM of various VLOOKUP columns. I can't get COUNTIF to
>> >> > > > work
>> >> > > > on either
>> >> > > > of these columns. I think it doesn't like SUM because it is a
>> >> > > > result of
>> >> > > > VLOOKUP columns.
>>
>>
>>