In a large spreasheet, I want to be able to count the number of rows where
column O is a nonblank (has some type of data entered - may be alpha or may
be a date) AND column P = "Y".

Can someone please point me in the right direction in terms of which formula
to use?

Thanks,
David

=sumproduct((isblank(o)=false)*(p="Y")

"David Lipetz" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> In a large spreasheet, I want to be able to count the number of rows where
> column O is a nonblank (has some type of data entered - may be alpha or
> may be a date) AND column P = "Y".
>
> Can someone please point me in the right direction in terms of which
> formula to use?
>
> Thanks,
> David
>

This formula =SUMPRODUCT((ISBLANK(O2:O425)=FALSE)*(P2:P425="Y")) does not
work correctly. The result should be 31 but the formula results in 66 which
is simply the number of rows in P that =Y without regards to O.

Ideas?


"Bobocat" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> =sumproduct((isblank(o)=false)*(p="Y")
>
> "David Lipetz" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>> In a large spreasheet, I want to be able to count the number of rows
>> where column O is a nonblank (has some type of data entered - may be
>> alpha or may be a date) AND column P = "Y".
>>
>> Can someone please point me in the right direction in terms of which
>> formula to use?
>>
>> Thanks,
>> David
>>
>
>

are you sure that the cell in column O is blank?
use Isblank(cell) to check? true = blank, false =not blank?

"David Lipetz" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> This formula =SUMPRODUCT((ISBLANK(O2:O425)=FALSE)*(P2:P425="Y")) does not
> work correctly. The result should be 31 but the formula results in 66
> which is simply the number of rows in P that =Y without regards to O.
>
> Ideas?
>
>
> "Bobocat" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>> =sumproduct((isblank(o)=false)*(p="Y")
>>
>> "David Lipetz" <(E-Mail Removed)> wrote in message
>> news:(E-Mail Removed)...
>>> In a large spreasheet, I want to be able to count the number of rows
>>> where column O is a nonblank (has some type of data entered - may be
>>> alpha or may be a date) AND column P = "Y".
>>>
>>> Can someone please point me in the right direction in terms of which
>>> formula to use?
>>>
>>> Thanks,
>>> David
>>>
>>
>>
>
>

OR select o2425, press F5 -> special -> blank
to check whether the "blank cell" is blank

"Bobocat" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> are you sure that the cell in column O is blank?
> use Isblank(cell) to check? true = blank, false =not blank?
>
> "David Lipetz" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>> This formula =SUMPRODUCT((ISBLANK(O2:O425)=FALSE)*(P2:P425="Y")) does not
>> work correctly. The result should be 31 but the formula results in 66
>> which is simply the number of rows in P that =Y without regards to O.
>>
>> Ideas?
>>
>>
>> "Bobocat" <(E-Mail Removed)> wrote in message
>> news:(E-Mail Removed)...
>>> =sumproduct((isblank(o)=false)*(p="Y")
>>>
>>> "David Lipetz" <(E-Mail Removed)> wrote in message
>>> news:(E-Mail Removed)...
>>>> In a large spreasheet, I want to be able to count the number of rows
>>>> where column O is a nonblank (has some type of data entered - may be
>>>> alpha or may be a date) AND column P = "Y".
>>>>
>>>> Can someone please point me in the right direction in terms of which
>>>> formula to use?
>>>>
>>>> Thanks,
>>>> David
>>>>
>>>
>>>
>>
>>
>
>

=SUMPRODUCT(--(LEN(O2:O425)>0),--(P2:P425="Y"))

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"David Lipetz" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> This formula =SUMPRODUCT((ISBLANK(O2:O425)=FALSE)*(P2:P425="Y")) does not
> work correctly. The result should be 31 but the formula results in 66
which
> is simply the number of rows in P that =Y without regards to O.
>
> Ideas?
>
>
> "Bobocat" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> > =sumproduct((isblank(o)=false)*(p="Y")
> >
> > "David Lipetz" <(E-Mail Removed)> wrote in message
> > news:(E-Mail Removed)...
> >> In a large spreasheet, I want to be able to count the number of rows
> >> where column O is a nonblank (has some type of data entered - may be
> >> alpha or may be a date) AND column P = "Y".
> >>
> >> Can someone please point me in the right direction in terms of which
> >> formula to use?
> >>
> >> Thanks,
> >> David
> >>
> >
> >
>
>