How to count unqiue combinations of interactions between rows in excel? -

so i've running trouble can help, i'm trying model weather.

im trying count number of times interactions happen between categoric data in excel, example data set:

     sunny      sunny      cloudy      p-cloudy      sunny       rainy      cloudy      sunny      sunny       etc... 

so on first day sunny, second day sunny, third cloudy , forth. how count number of times each weather type changes, i.e.

  sunny sunny     2   sunny p-cloudy  0   sunny cloudy    1     sunny rainy     1   cloudy p-cloudy 1    cloudy sunny    1   cloudy rainy    0   etc.. 

any appreciated.

row           b       c        d                            e                             f                           g 1     today     tomorrow                         2     sunny     =a3              sunny                        cloudy                        p-cloudy                    rainy 3     sunny     =a4     sunny    =countifs(a:a,$d3,b:b,e$2) =countifs(a:a,$d3,b:b,f$2)  =countifs(a:a,$d3,b:b,g$2)  =countifs(a:a,$d3,b:b,h$2) 4     cloudy    =a5     cloudy   =countifs(a:a,$d4,b:b,e$2) =countifs(a:a,$d4,b:b,f$2)  =countifs(a:a,$d4,b:b,g$2)  =countifs(a:a,$d4,b:b,h$2) 5     p-cloudy  =a6     p-cloudy =countifs(a:a,$d5,b:b,e$2) =countifs(a:a,$d5,b:b,f$2)  =countifs(a:a,$d5,b:b,g$2)  =countifs(a:a,$d5,b:b,h$2) 6     sunny     =a7     rainy    =countifs(a:a,$d6,b:b,e$2) =countifs(a:a,$d6,b:b,f$2)  =countifs(a:a,$d6,b:b,g$2)  =countifs(a:a,$d6,b:b,h$2) 7     rainy     =a8                      8     cloudy    =a9                      9     sunny     =a10                         10    sunny                          

i hope helps. :)

ok hate rewrite column references make them absolute ($a:$a & $b:$b) make copy , pasting easier.

that being said vertical list of days in column c today column, , row 2 list weather transitioned next