View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Matt Matt is offline
external usenet poster
 
Posts: 516
Default Counting Formula

I have two columns that I need to count up the values of. One column is a
"Status" column that either have the values or "Live" or "Expired". The
second column, which is a "Type" column, have the values of "Production",
"Resources", or "Communication". I'm trying to figure out how to count up all
"Expired" values that is located under "Production"; All "Expired" values for
"Resources" and so forth. Can anyone help? Thanks!