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" wrote in message
...
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


--
olasa
------------------------------------------------------------------------
olasa's Profile: http://www.excelforum.com/member.php...o&userid=17760
View this thread: http://www.excelforum.com/showthread...hreadid=384698