Counting cell depending on certain crieteria

  • Thread starter Thread starter starguy
  • Start date Start date
And I forget to preceede the second comparision with -- . So the correct
formula must be
=SUMPRODUCT(--($A$5:$A$50<>""),--($B$5:$B$50=""))
 

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

trying to simplify an Array formula 4
How to count interstitial blank cells? 3
Display error message if a cell is left blank 8
counta function can any one explain the example counting 2 4
count how many rows contain nonblank in column A and blank in colu 5
Count fowmula that will look for multiple words 2
Cell address in a range 7
if statement 2

Back
Top