ExcelBanter - Count the non blank cells

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

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Count the non blank cells (https://www.excelbanter.com/excel-worksheet-functions/118290-count-non-blank-cells.html)

vijaydsk1970

Count the non blank cells

How to count the non blank cells in a column corresponding with certain
criteria in an adjacent column.

Thank in advance

Stefi

Count the non blank cells

=SUMPRODUCT(--(I1:I14<""),--(J1:J14="a"))

How to count the non blank cells in a column (COLUMN I) corresponding with certain
criteria in an adjacent column (COLUMN J) .

Regards,
Stefi

vijaydsk1970

Count the non blank cells

Thank you Stefi

"Stefi" wrote:

=SUMPRODUCT(--(I1:I14<""),--(J1:J14="a"))

How to count the non blank cells in a column (COLUMN I) corresponding with certain
criteria in an adjacent column (COLUMN J) .

Regards,
Stefi

Stefi

Count the non blank cells

You are welcome! Thanks for the feedback!
Stefi

€žvijaydsk1970€ ezt Ã*rta:

Thank you Stefi

"Stefi" wrote:

=SUMPRODUCT(--(I1:I14<""),--(J1:J14="a"))

How to count the non blank cells in a column (COLUMN I) corresponding with certain
criteria in an adjacent column (COLUMN J) .

Regards,
Stefi

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