My formula's seem to slow down my file

[Ramballah]

Hello everyone,

I have the feeling one of my formula's seem to slow down my file.
I don't know exactly which one (I'm sorry)
Can anyone tell me which one it is, and if its possible to make it faster?

=MAX(B:B)
=COUNTIFS(E3:E500, "Win", H3:H500, "Me")/COUNTIF(H3:H500,"Me")
=COUNTIF(F:F,"heads")
=MAX(FREQUENCY(IF(F:F="heads", ROW(F:F)), IF(F:F<>"Heads", ROW(F:F))))
=COUNTIFS(D3:D500,"Heads",E3:E500,"win",H3:H500,"me")
=COUNTIF(F:F,"tails")
=MAX(FREQUENCY(IF(F:F="Tails", ROW(F:F)), IF(F:F<>"Tails", ROW(F:F))))
=COUNTIFS(D3:D500,"Tails",E3:E500,"win",H3:H500,"me")

Feel free to tell me what to do as I'm completely lost due to me neglecting this file for over 2 years.

Thanks in advance,
Ramballah

 

[jasonb75]

Two formulas. The frequency(if arrays should be limited to the actual data range rather than entire columns.

Assuming 500 rows of data, those formulas are wasting approximately 99.95% of the processing effort.

 

[Ramballah]

Two formulas. The frequency(if arrays should be limited to the actual data range rather than entire columns.

Assuming 500 rows of data, those formulas are wasting approximately 99.95% of the processing effort.

well since I dont want it to calculate row 1-2 cause row 1 is where I use my macro and row 2 is the headers of the charts. What should I do?

 

[Ramballah]

well since I dont want it to calculate row 1-2 cause row 1 is where I use my macro and row 2 is the headers of the charts. What should I do?

nvm i read it wrong. I'll edit it to just row 500