Have you tried funcion:
=IF(D:D="general",COUNTA(D:D))

Eva

"Lori" wrote:

I'm trying to count populated cells in a column, based on values in another
column. As example, if Column D is populated as General, I want to count the
number of occurances in Column E. Column D has multiple values. I've tried
pivot tables, but it isn't producing what I need.