I have attached a ss where im trying to build some analysis.
In tab "Analysis" i would like to count the number of instances where ratings have changes
STD to HIGH
HIGH to STD
In tab input D1 there is previous rating and current rating, in tab "Loookup Tables" i have rated High=1, MED=2 & STD =3.
So if 15 records moved from STD to HIGH and 23 from HIGH to STD, the countifs would return
Can someone suggest the countif?