Countif with conditions

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

Guest

Again, thanks in advance to all the helpers here.

I need to count non-blanks cells in column B depending on the content of the
columnA.

A B
50-01 12/12/05
50-01
30-02
 
Hi!

You didn't say what the dependent condition was.

Use this as a guide and fill in what the logical test is:

=SUMPRODUCT(--(A1:A10...some_logical_test),--(B1:B10<>""))

Biff
 
Thanks Biff, works perfect.


Biff said:
Hi!

You didn't say what the dependent condition was.

Use this as a guide and fill in what the logical test is:

=SUMPRODUCT(--(A1:A10...some_logical_test),--(B1:B10<>""))

Biff
Click to expand...
 
You must log in or register to reply here.

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 with Excel 2007 COUNTIFS! 0
Sum value between two dates and copy to new cell 6
Sum amounts based on date field 6
Countif Formulas 2
Modifying a complex date formual to count months 4
Date Function 2
countifs Function not giving desired result with date criteria 2
How to get largest date from a Vlookup 1

Back
Top