Sum numbers based on value in other cells

L

Lori

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.
 
B

Bob Phillips

=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)
 
L

Lori

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