I am trying to count the number of "x" in a row in multiple worksheets. This
is the formula I have been trying to use
=COUNTIF('Jan 05'!C4:AG4+'Feb 05'!C4:AD4+'Mar 05'!C4:AG4+'Apr 05'!C4:AF4, "x")

Why isn't it working. Please help.

Thanks
Amanda

Try it this way:

=COUNTIF('Jan 05'!C4:AG4,"x")+COUNTIF('Feb 05'!C4:AD4,"x")+
COUNTIF('Mar 05'!C4:AG4,"x")+COUNTIF('Apr 05'!C4:AF4, "x")

If you had to do it for all 12 months this would result in a pretty long
formula. There's a shorter alternative but it requires that all the ranges
are the same.

Biff

"Amanda" wrote in message
...
I am trying to count the number of "x" in a row in multiple worksheets.
This
is the formula I have been trying to use
=COUNTIF('Jan 05'!C4:AG4+'Feb 05'!C4:AD4+'Mar 05'!C4:AG4+'Apr 05'!C4:AF4,
"x")

Why isn't it working. Please help.

Thanks
Amanda

Thanks, I will try that. I do have to do it for the 12 months but each range
is different which is a bumma (as each month has a different amount of days
in it). Any other ideas would be greatly appreciated.

"T. Valko" wrote:

Try it this way:

=COUNTIF('Jan 05'!C4:AG4,"x")+COUNTIF('Feb 05'!C4:AD4,"x")+
COUNTIF('Mar 05'!C4:AG4,"x")+COUNTIF('Apr 05'!C4:AF4, "x")

If you had to do it for all 12 months this would result in a pretty long
formula. There's a shorter alternative but it requires that all the ranges
are the same.

Biff

"Amanda" wrote in message
...
I am trying to count the number of "x" in a row in multiple worksheets.
This
is the formula I have been trying to use
=COUNTIF('Jan 05'!C4:AG4+'Feb 05'!C4:AD4+'Mar 05'!C4:AG4+'Apr 05'!C4:AF4,
"x")

Why isn't it working. Please help.

Thanks
Amanda

Hi Amanda

Even though each month has differing numbers of days, presumably AE4:AG4
will be blank in February, so it wouldn't matter.

Why not just put a formula in AH4 on each sheet - you can do then all at
once by selecting the Jan hold down Shift and select Dec, and this will
group the sheets
In cell AH4 enter
=COUNTIF(C4:AG4,"x")
Click on any sheet to Ungroup then again

For your summary
=SUM(Jan:Dec!AH4)
This assumes that the sheets are in chronological order.

Other wise create 2 new sheets called First and Last and position them
so that they "sandwich" your Monthly sheets, but keep your Summary sheet
outside of the sandwich.
=SUM(First:Last!AH4)
will not worry about the order inside First and Last, and you can drag
sheets in and out of the range to add differing numbers of months if
required.


--
Regards

Roger Govier


"Amanda" wrote in message
...
Thanks, I will try that. I do have to do it for the 12 months but each
range
is different which is a bumma (as each month has a different amount of
days
in it). Any other ideas would be greatly appreciated.

"T. Valko" wrote:

Try it this way:

=COUNTIF('Jan 05'!C4:AG4,"x")+COUNTIF('Feb 05'!C4:AD4,"x")+
COUNTIF('Mar 05'!C4:AG4,"x")+COUNTIF('Apr 05'!C4:AF4, "x")

If you had to do it for all 12 months this would result in a pretty
long
formula. There's a shorter alternative but it requires that all the
ranges
are the same.

Biff

"Amanda" wrote in message
...
I am trying to count the number of "x" in a row in multiple
worksheets.
This
is the formula I have been trying to use
=COUNTIF('Jan 05'!C4:AG4+'Feb 05'!C4:AD4+'Mar 05'!C4:AG4+'Apr
05'!C4:AF4,
"x")

Why isn't it working. Please help.

Thanks
Amanda

That might work, But I am trying to count different ranges for each month. IE
sometimes I need to count from 1/5/05 - 1/5/06 and other times I need to
count from 27/4/05 - 27/4/06. But they overlap into other years which are on
different sheets. I have tried entering the first formula that you gave me,
but using it through different sheets and it dosen't seem to work. Is it
possible to use that formula in the way I am trying.

"Roger Govier" wrote:

Hi Amanda

Even though each month has differing numbers of days, presumably AE4:AG4
will be blank in February, so it wouldn't matter.

Why not just put a formula in AH4 on each sheet - you can do then all at
once by selecting the Jan hold down Shift and select Dec, and this will
group the sheets
In cell AH4 enter
=COUNTIF(C4:AG4,"x")
Click on any sheet to Ungroup then again

For your summary
=SUM(Jan:Dec!AH4)
This assumes that the sheets are in chronological order.

Other wise create 2 new sheets called First and Last and position them
so that they "sandwich" your Monthly sheets, but keep your Summary sheet
outside of the sandwich.
=SUM(First:Last!AH4)
will not worry about the order inside First and Last, and you can drag
sheets in and out of the range to add differing numbers of months if
required.


--
Regards

Roger Govier


"Amanda" wrote in message
...
Thanks, I will try that. I do have to do it for the 12 months but each
range
is different which is a bumma (as each month has a different amount of
days
in it). Any other ideas would be greatly appreciated.

"T. Valko" wrote:

Try it this way:

=COUNTIF('Jan 05'!C4:AG4,"x")+COUNTIF('Feb 05'!C4:AD4,"x")+
COUNTIF('Mar 05'!C4:AG4,"x")+COUNTIF('Apr 05'!C4:AF4, "x")

If you had to do it for all 12 months this would result in a pretty
long
formula. There's a shorter alternative but it requires that all the
ranges
are the same.

Biff

"Amanda" wrote in message
...
I am trying to count the number of "x" in a row in multiple
worksheets.
This
is the formula I have been trying to use
=COUNTIF('Jan 05'!C4:AG4+'Feb 05'!C4:AD4+'Mar 05'!C4:AG4+'Apr
05'!C4:AF4,
"x")

Why isn't it working. Please help.

Thanks
Amanda

Hi Amanda

If you have the Countif formula in AH4 on each sheet, then the
SUM(First:Last!AH4) should work fine.

Perhaps I'm not quite understanding your sheets and your ranges.
You talk about counting "X"'s between C and AD and C and AG which would
be 28 and 31 cells respectively.
So I imagined each column was 1 day within the month denoted by the Tab
name.

So if you pulled into the "sandwich", May05 though Apr06, and left Apr05
outside of the "sandwich" then on your summary sheet it would be
=SUM(First:Last!AH4)+COUNTIF(Apr05!AD4:AG4,"x")-COUNTIF(Apr06!AD4:AG4,"x")

Looking at your Tabs you should see the order
Summary, Apr05,First,May05,Jun05
.........Mar06,Apr06,Last,May06,Jun06.....

--
Regards

Roger Govier


"Amanda" wrote in message
...
That might work, But I am trying to count different ranges for each
month. IE
sometimes I need to count from 1/5/05 - 1/5/06 and other times I need
to
count from 27/4/05 - 27/4/06. But they overlap into other years which
are on
different sheets. I have tried entering the first formula that you
gave me,
but using it through different sheets and it dosen't seem to work. Is
it
possible to use that formula in the way I am trying.

"Roger Govier" wrote:

Hi Amanda

Even though each month has differing numbers of days, presumably
AE4:AG4
will be blank in February, so it wouldn't matter.

Why not just put a formula in AH4 on each sheet - you can do then all
at
once by selecting the Jan hold down Shift and select Dec, and this
will
group the sheets
In cell AH4 enter
=COUNTIF(C4:AG4,"x")
Click on any sheet to Ungroup then again

For your summary
=SUM(Jan:Dec!AH4)
This assumes that the sheets are in chronological order.

Other wise create 2 new sheets called First and Last and position
them
so that they "sandwich" your Monthly sheets, but keep your Summary
sheet
outside of the sandwich.
=SUM(First:Last!AH4)
will not worry about the order inside First and Last, and you can
drag
sheets in and out of the range to add differing numbers of months if
required.


--
Regards

Roger Govier


"Amanda" wrote in message
...
Thanks, I will try that. I do have to do it for the 12 months but
each
range
is different which is a bumma (as each month has a different amount
of
days
in it). Any other ideas would be greatly appreciated.

"T. Valko" wrote:

Try it this way:

=COUNTIF('Jan 05'!C4:AG4,"x")+COUNTIF('Feb 05'!C4:AD4,"x")+
COUNTIF('Mar 05'!C4:AG4,"x")+COUNTIF('Apr 05'!C4:AF4, "x")

If you had to do it for all 12 months this would result in a
pretty
long
formula. There's a shorter alternative but it requires that all
the
ranges
are the same.

Biff

"Amanda" wrote in message
...
I am trying to count the number of "x" in a row in multiple
worksheets.
This
is the formula I have been trying to use
=COUNTIF('Jan 05'!C4:AG4+'Feb 05'!C4:AD4+'Mar 05'!C4:AG4+'Apr
05'!C4:AF4,
"x")

Why isn't it working. Please help.

Thanks
Amanda

Will this formula work if I was to get the ranges from other excel pages, ie:
from other years?

"T. Valko" wrote:

Try it this way:

=COUNTIF('Jan 05'!C4:AG4,"x")+COUNTIF('Feb 05'!C4:AD4,"x")+
COUNTIF('Mar 05'!C4:AG4,"x")+COUNTIF('Apr 05'!C4:AF4, "x")

If you had to do it for all 12 months this would result in a pretty long
formula. There's a shorter alternative but it requires that all the ranges
are the same.

Biff

"Amanda" wrote in message
...
I am trying to count the number of "x" in a row in multiple worksheets.
This
is the formula I have been trying to use
=COUNTIF('Jan 05'!C4:AG4+'Feb 05'!C4:AD4+'Mar 05'!C4:AG4+'Apr 05'!C4:AF4,
"x")

Why isn't it working. Please help.

Thanks
Amanda