so my formula is this

=SUMPRODUCT(--(B27:B8999<>E27:E8999))

how to convert this to the proper countifs?

the logic to my formula is it is suppose to count how many records of Column B has changed in Column E.

TIA.