View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Lori Lori is offline
external usenet poster
 
Posts: 272
Default Sum numbers based on value in other cells

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.