In column B I have text that may or may not contain the word "foo".
In column D I have cells that may or may not contain text.
I want to be able to count the number of rows where BX contains "foo"
and column D is not empty (or is empty - I can take either).
What I have is:
=SUMPRODUCT((B1:B700="*foo*")*(D1:D700=""))
Any help is appriciated.
Thank you,
Heather.
--
peacelittleone
------------------------------------------------------------------------
peacelittleone's Profile:
http://www.excelforum.com/member.php...o&userid=20937
View this thread:
http://www.excelforum.com/showthread...hreadid=379321