Need formula based on:
COUNTA(E:E) AND COUNTIF(F:F,"Sarah")
But how do I put these two requirements together?
Thanks
Need formula based on:
COUNTA(E:E) AND COUNTIF(F:F,"Sarah")
But how do I put these two requirements together?
Thanks
=SUMPRODUCT(--(F1:F100="Sarah"),--(NOT(ISBLANK(E1:E100))
--
HTH
RP
(remove nothere from the email address if mailing direct)
"luvthavodka" <[email protected]> wrote in message
news:[email protected]...
> Need formula based on:
>
> COUNTA(E:E) AND COUNTIF(F:F,"Sarah")
>
> But how do I put these two requirements together?
>
> Thanks
=AND(COUNTA(E:E),COUNTIF(F:F,"Sarah"))
or maybe that should be
=COUNTA(E:E)=COUNTIF(F:F,"Sarah")
Ola
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks