Count the non blank cells

G

Guest

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

Thank in advance
 
G

Guest

=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
 
G

Guest

You are welcome! Thanks for the feedback!
Stefi

„vijaydsk1970†ezt írta:
 

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

Return Each Last Non-blank Cell, Value 2 Column Offset, Many GAPS 1
COUNTIF ? 6
COUNTIF using conditions 2
Counting blank cells between non-blank cells 4
COUNT NON-BLANK CELLS WITH REFERENCE TO ANOTHER COLUMN 1
Help needed 0
SUMIF with criteria "<>" & "=" 4
Count nonblank cells based on another column 1

Top