View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
smorgan
 
Posts: n/a
Default Formula for counting multiple variables in a spreadsheet

I have a spreadsheet with multiple columns. I am trying to create a formula
that would return a count for the number of values in column A that has the
same value I am looking for in column E.

The formula that I thought would be if(e4:e1000="FL1",countif(A4:a100,a4),0)

Any ideas....