Sum numbers based on value in other cells

[Guest]

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.

 

[Bob Phillips]

=COUNTIF(D,"General")

If you really meant sum E, then use

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

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)

 

[Guest]

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

Eva

 

[Guest]

This returns a "Value" error. I populated the D string and the E string.
Any other thoughts? This seems like it should be simple!!