View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
UT
 
Posts: n/a
Default count non blank cells with criteria

I need to count non blank cells that match a condition.

For example i want to count number of entries in Column "B" for "ANTH 328"
course.

A B
ANTH 328 PC
ANTH 328
ANTH 328 PC

I have tried DCOUNTA and combination of functions. Nothing is working. Help
will be greatly appreciated.