COUNTIF
 

I have four seperate worksheets for example 1=totals 2= xxx0 3 = yyy1
I can get the first xxx0 to give me totals on my totals page wit formula
COUNTIF(xxx0!G10:Z28,"xxxx") but when i try to incorporate the third sheet
and beyond it will not go...Please help

COUNTIF
 

Hi,

what do you mean by "incorporate"?

Does
=COUNTIF(yyy1!G10:Z28,"xxxx")
work?

If you are trying to do a 3-D formula using COUNTIF - this function does not
support 3D references.

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"tcomm" wrote:

I have four seperate worksheets for example 1=totals 2= xxx0 3 = yyy1
I can get the first xxx0 to give me totals on my totals page wit formula
COUNTIF(xxx0!G10:Z28,"xxxx") but when i try to incorporate the third sheet
and beyond it will not go...Please help

COUNTIF
 

Yes COUNTIF(yyy1!G10:Z28,"xxxx") works but if i have sheet 2 xxx0 and sheet 3
yyy1 with same data i want it to appear in same totals cell on sheet 1

"Shane Devenshire" wrote:

Hi,

what do you mean by "incorporate"?

Does
=COUNTIF(yyy1!G10:Z28,"xxxx")
work?

If you are trying to do a 3-D formula using COUNTIF - this function does not
support 3D references.

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"tcomm" wrote:

I have four seperate worksheets for example 1=totals 2= xxx0 3 = yyy1
I can get the first xxx0 to give me totals on my totals page wit formula
COUNTIF(xxx0!G10:Z28,"xxxx") but when i try to incorporate the third sheet
and beyond it will not go...Please help

COUNTIF
 

Hi,

Since you can't reference 3D ranges countif functions you will need to use
multiple countif's, one for each sheet.

=COUNTIF(yyy1!G10:Z28,"xxxx")+COUNTIF(xxx0!G10:Z28 ,"xxxx")+...

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"tcomm" wrote:

Yes COUNTIF(yyy1!G10:Z28,"xxxx") works but if i have sheet 2 xxx0 and sheet 3
yyy1 with same data i want it to appear in same totals cell on sheet 1

"Shane Devenshire" wrote:

Hi,

what do you mean by "incorporate"?

Does
=COUNTIF(yyy1!G10:Z28,"xxxx")
work?

If you are trying to do a 3-D formula using COUNTIF - this function does not
support 3D references.

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"tcomm" wrote:

I have four seperate worksheets for example 1=totals 2= xxx0 3 = yyy1
I can get the first xxx0 to give me totals on my totals page wit formula
COUNTIF(xxx0!G10:Z28,"xxxx") but when i try to incorporate the third sheet
and beyond it will not go...Please help