count non blank cells which meet criteria in another column

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

Guest

I'm working with 2 columns out of an Excel spreadsheet. First column "B" is
list of names (some cells may be blank) and the second column "F" contains
years (2001, 2002, etc.). I'd like to count non blank cells in "B" which
meet the criteria (2005) in the years "F" column.
 
Hi

one method
=SUMPRODUCT(--(B7:B100<>""),--(F7:F100=2005))

Cheers
JulieD
 
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

count cells in a table that meet multiple criteria 1
Counting in multiple column 2
Counting cells with multiple criteria 3
Count if dates meet certain criteria 10
Counting NON-Blank fields 2
COUNTIF ? 6
Function Help - Forecast Date past due, adjacent cell is blank. Needto highlight the blank cell. 2
Return Each Last Non-blank Cell, Value 2 Column Offset, Many GAPS 1

Back
Top