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)?

countif, maybe?
 

How many were elite:
=COUNTIf(A1:A100,"elite")
How many were elite but are no platinum
=SUMPRODUCT(--(A1:A100="elite"),--(b1:b100="platinum")
Make a table
C1:F1- enter the types (elite, platinum, gold, silver, standard)
C2:C6 - enter the types (elite, platinum, gold, silver, standard)
D2 use =SUMPRODUCT(--(A1:A100=$C2),--(b1:b100=C$1)
Copy across to F2 and down to row 6
OR learn about Pivot Tables
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"PFLY" wrote in message
...
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)?