Where ever the word "Hanks" is found Count Count the non-blanks cells in
column D
Where ever the word "Hanks" is found Count Count the non-blanks cells in
column D
Maybe something like this:
=SUMPRODUCT((A1:A100="frank")*(D1:D100<>""))
HTH
Jean-Guy
"Sherri" wrote:
> Where ever the word "Hanks" is found Count Count the non-blanks cells in
> column D
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks