Count the non blank cells

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

Thank in advance
 
=SUMPRODUCT(--(I1:I14 said:
How to count the non blank cells in a column (COLUMN I) corresponding with certain
criteria in an adjacent column (COLUMN J) .
Click to expand...

Regards,
Stefi
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help needed 0
COUNTIF ? 6
Return Each Last Non-blank Cell, Value 2 Column Offset, Many GAPS 1
Total a column contingent upon the cell to the right being non-bla 3
Function Help - Forecast Date past due, adjacent cell is blank. Needto highlight the blank cell. 2
Counting blank cells between non-blank cells 4
COUNTIF using conditions 2
COUNT NON-BLANK CELLS WITH REFERENCE TO ANOTHER COLUMN 1

Back
Top