=COUNTIF(D:D,"General")

If you really meant sum E, then use

=SUMIF(D:D,"General",E:E)

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"Lori" wrote in message
...
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.