Thread: countif, maybe?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
PFLY PFLY is offline
external usenet poster
 
Posts: 17
Default countif, maybe?

I have two columns of Status Levels from elite, platinum, gold, silver, and
standard. The column on the left is the new status and the column on the left
is thier old status. What formula can I do to count the elite (for example)
status dealers in the left column and find how many were from each level
before (how many were elite, platinum..etc from the column on the right)?