nested functions

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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(ViewData!
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



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

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

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
 
Back
Top