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

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

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

The way I have my pages set up it that each document has tabs for each month
of the year. And there are separate saves for each year.

"Roger Govier" wrote:

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

Hi Amanda

Why not copy tabs from the other year?
In workbook 2005
Group tabs by selecting Jan, holding Shift and Selecting Dec
Right click on any tabMove or Copy
tick Copy
use dropdown to select workbook 2006

In 2006 you will Jan(2), Feb(2) etc.
Rename your Tabs to reflect Jan05, Jan06 etc.

If you want to leave 2005 and 2006 as they are, having selected the tabs
from 2005, select New Workbook as the destination. Save this as Combined
Data. Carry out task for 2006 giving destination as Combined Data

--
Regards

Roger Govier


"Amanda" wrote in message
...
The way I have my pages set up it that each document has tabs for each
month
of the year. And there are separate saves for each year.

"Roger Govier" wrote:

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

Thanks Heaps Roger. You have saved me alot of pain and suffering. LOL.
Thankyou again.

"Roger Govier" wrote:

Hi Amanda

Why not copy tabs from the other year?
In workbook 2005
Group tabs by selecting Jan, holding Shift and Selecting Dec
Right click on any tabMove or Copy
tick Copy
use dropdown to select workbook 2006

In 2006 you will Jan(2), Feb(2) etc.
Rename your Tabs to reflect Jan05, Jan06 etc.

If you want to leave 2005 and 2006 as they are, having selected the tabs
from 2005, select New Workbook as the destination. Save this as Combined
Data. Carry out task for 2006 giving destination as Combined Data

--
Regards

Roger Govier


"Amanda" wrote in message
...
The way I have my pages set up it that each document has tabs for each
month
of the year. And there are separate saves for each year.

"Roger Govier" wrote:

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

Hi Amanda

You're more than welcome.
Glad you got it to work.

--
Regards

Roger Govier


"Amanda" wrote in message
...
Thanks Heaps Roger. You have saved me alot of pain and suffering. LOL.
Thankyou again.

"Roger Govier" wrote:

Hi Amanda

Why not copy tabs from the other year?
In workbook 2005
Group tabs by selecting Jan, holding Shift and Selecting Dec
Right click on any tabMove or Copy
tick Copy
use dropdown to select workbook 2006

In 2006 you will Jan(2), Feb(2) etc.
Rename your Tabs to reflect Jan05, Jan06 etc.

If you want to leave 2005 and 2006 as they are, having selected the
tabs
from 2005, select New Workbook as the destination. Save this as
Combined
Data. Carry out task for 2006 giving destination as Combined Data

--
Regards

Roger Govier


"Amanda" wrote in message
...
The way I have my pages set up it that each document has tabs for
each
month
of the year. And there are separate saves for each year.

"Roger Govier" wrote:

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