At this point Excel hates me, I can feel it. So this is what my next issue
is. I have column B which the user places an "x" in the cell that corresponds
with a day of the week in column A. I have column C that has an "x" placed
into the cell when a certain code is inputed into column D, What I am trying
to do is have a cell at the bottom, give me a percentage of the X's between
column B & C. Can anyone shed light on this for me please..

Thank you ahead of time!

Excel loves you!! It just has difficulty expressing that love.

Use COUNTIF(). COUNTIF(B1:B100,"X") and the similar for column C.

Then take the ratios, etc.
--
Gary''s Student


"VegasBurger" wrote:

At this point Excel hates me, I can feel it. So this is what my next issue
is. I have column B which the user places an "x" in the cell that corresponds
with a day of the week in column A. I have column C that has an "x" placed
into the cell when a certain code is inputed into column D, What I am trying
to do is have a cell at the bottom, give me a percentage of the X's between
column B & C. Can anyone shed light on this for me please..

Thank you ahead of time!

No success with that formula unless again I am doing it wrong. I basically
need to show a percentage of X's from column C vs column B

"Gary''s Student" wrote:

Excel loves you!! It just has difficulty expressing that love.

Use COUNTIF(). COUNTIF(B1:B100,"X") and the similar for column C.

Then take the ratios, etc.
--
Gary''s Student


"VegasBurger" wrote:

At this point Excel hates me, I can feel it. So this is what my next issue
is. I have column B which the user places an "x" in the cell that corresponds
with a day of the week in column A. I have column C that has an "x" placed
into the cell when a certain code is inputed into column D, What I am trying
to do is have a cell at the bottom, give me a percentage of the X's between
column B & C. Can anyone shed light on this for me please..

Thank you ahead of time!

My explanation was a little sketchy. Let's say we have this data from B1
thru C20:

0 0
0 X
0 0
X 0
0 0
0 X
X 0
0 0
0 0
X 0
0 0
0 X
0 0
X 0
0 0
0 0
X 0
0 0
0 X
0 0


and in E1 the formula =COUNTIF(B1:B100,"X")
and in F1 the formula =COUNTIF(C1:C100,"X")

E1 shows 5 and F1 shows 4

The total X's are 9 and the percent from column B is 5/9 or about 55.55%
The percent from column C is 4/9 or about 44.44%.

The ratio of B to C is 5/4 or 1.25/1

Let me know if this helps.
--
Gary''s Student


"VegasBurger" wrote:

No success with that formula unless again I am doing it wrong. I basically
need to show a percentage of X's from column C vs column B

"Gary''s Student" wrote:

Excel loves you!! It just has difficulty expressing that love.

Use COUNTIF(). COUNTIF(B1:B100,"X") and the similar for column C.

Then take the ratios, etc.
--
Gary''s Student


"VegasBurger" wrote:

At this point Excel hates me, I can feel it. So this is what my next issue
is. I have column B which the user places an "x" in the cell that corresponds
with a day of the week in column A. I have column C that has an "x" placed
into the cell when a certain code is inputed into column D, What I am trying
to do is have a cell at the bottom, give me a percentage of the X's between
column B & C. Can anyone shed light on this for me please..

Thank you ahead of time!

=COUNTIF(C:C,"X")/COUNTIF(B:B,"X")

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"VegasBurger" wrote in message
...
No success with that formula unless again I am doing it wrong. I basically
need to show a percentage of X's from column C vs column B

"Gary''s Student" wrote:

Excel loves you!! It just has difficulty expressing that love.

Use COUNTIF(). COUNTIF(B1:B100,"X") and the similar for column C.

Then take the ratios, etc.
--
Gary''s Student


"VegasBurger" wrote:

At this point Excel hates me, I can feel it. So this is what my next
issue
is. I have column B which the user places an "x" in the cell that
corresponds
with a day of the week in column A. I have column C that has an "x"
placed
into the cell when a certain code is inputed into column D, What I am
trying
to do is have a cell at the bottom, give me a percentage of the X's
between
column B & C. Can anyone shed light on this for me please..

Thank you ahead of time!

Thanks Bob
--
Gary''s Student


"Bob Phillips" wrote:

=COUNTIF(C:C,"X")/COUNTIF(B:B,"X")

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"VegasBurger" wrote in message
...
No success with that formula unless again I am doing it wrong. I basically
need to show a percentage of X's from column C vs column B

"Gary''s Student" wrote:

Excel loves you!! It just has difficulty expressing that love.

Use COUNTIF(). COUNTIF(B1:B100,"X") and the similar for column C.

Then take the ratios, etc.
--
Gary''s Student


"VegasBurger" wrote:

At this point Excel hates me, I can feel it. So this is what my next
issue
is. I have column B which the user places an "x" in the cell that
corresponds
with a day of the week in column A. I have column C that has an "x"
placed
into the cell when a certain code is inputed into column D, What I am
trying
to do is have a cell at the bottom, give me a percentage of the X's
between
column B & C. Can anyone shed light on this for me please..

Thank you ahead of time!