Countup on change of matching cells

Good afternoon everyone

I have a problem I have been unable to work out not sure if this will be a formula or a VBA still learning

Columns A to I I have all my data I am using

I would like a count in Column J when Columns A,C,E,F,G,H,I change going down the sheet a new count will be placed in Column J
there may be multiple rows of the same information in Columns A,C,E,F,G,H,I a row going down once it changes value the above values will not show again as all the data has been presorted on another sheet

I have placed a sample on Column K

Any help or guides would be great
JustinwB

Maybe, put this on J2 and copied down as necessary:

=IF(I2="","",SUM(--(FREQUENCY(I$2:I2,I$2:I2)>0)))

Good afternoon Azumi

Thank you for your help

Is it possible to add another column to the Frequency
Coloumn F and H just in case Collect paperwork over laps I have seen this does happen

Good afternoon Bo_Ry

this is working great I have tested around 100 rows of trucks and they are all working with the count adding one. My next step is top run it with over 2000 rows with 3 weeks worth of data

Will let you know in the next few hours if everything is working I have never used the SUMPRODUCT before

Good afternoon Bo_Ry

I have just finished placing all my reports together from last week was 359 rows have to do the full year
I just refreshed the page
Thank you for a updated formula

You are the best