ExcelBanter - Excel

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Excel (https://www.excelbanter.com/excel-discussion-misc-queries/75778-excel.html)

Sherri

Excel

Where ever the word "Hanks" is found Count Count the non-blanks cells in
column D

pinmaster

Excel

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

All times are GMT +1. The time now is 10:08 AM.