nested functions

I would like to nest a function that would first filter
the data in a column and then look for all of the "y" in
that filtered column. I thought this would work
=IF(COUNTIF(ViewData!W5:W1196,"Joe"),COUNTIF(ViewD ata!
FR4:FR1195,"Y"))

But it only gives me back the count for all of the "y"
that do not belong to "Joe".

THANKS!
Pauline

Hi
try
=SUMPRODUCT(--(ViewData!W5:W1196="Joe"),--(ViewData!FR5:FR1196="y"))

--
Regards
Frank Kabel
Frankfurt, Germany


wrote:
I would like to nest a function that would first filter
the data in a column and then look for all of the "y" in
that filtered column. I thought this would work
=IF(COUNTIF(ViewData!W5:W1196,"Joe"),COUNTIF(ViewD ata!
FR4:FR1195,"Y"))

But it only gives me back the count for all of the "y"
that do not belong to "Joe".

THANKS!
Pauline

That worked!!! Thank you so much!!!
-----Original Message-----
Hi
try
=SUMPRODUCT(--(ViewData!W5:W1196="Joe"),--(ViewData!
FR5:FR1196="y"))

--
Regards
Frank Kabel
Frankfurt, Germany


wrote:
I would like to nest a function that would first filter
the data in a column and then look for all of the "y"
in
that filtered column. I thought this would work
=IF(COUNTIF(ViewData!W5:W1196,"Joe"),COUNTIF(ViewD ata!
FR4:FR1195,"Y"))

But it only gives me back the count for all of the "y"
that do not belong to "Joe".

THANKS!
Pauline
.

If what you want is all the "y" that DO belong to "joe" try

=SUMPRODUCT(--(ViewData!W5:W1196="Joe"),--(ViewData!
FR4:FR1195="Y"))

I assume that the difference in the postion of your ranges
is unpurpose (w5:w1196 & fr4:fr1195) according to this the
formula will assume that row 5 in W belongs to row 4 in FR
and so on...

Cheers
Juan


-----Original Message-----
I would like to nest a function that would first filter
the data in a column and then look for all of the "y" in
that filtered column. I thought this would work
=IF(COUNTIF(ViewData!W5:W1196,"Joe"),COUNTIF(View Data!
FR4:FR1195,"Y"))

But it only gives me back the count for all of the "y"
that do not belong to "Joe".

THANKS!
Pauline
.