Count total people within a group of ranges | Sum total value for ranges and list average

These will give you the count...
H3=COUNTIF($E$3:$E$402,H2)
I3=COUNTIFS($E$3:$E$402,">"&H2,$E$3:$E$402,"<="&I2)
copied across

For future reference, please ask ALL your questions IN the thread, that way members can see if they want to tackle your question, without needing to open files

Is there any way I can count the total number of people in this range and the other ranges from column F.

So that it appears in only row 3 for each respective range?

Is there also a function that can product and average of the total count for each range that would go in row 3 underneath the person count

And also a high low range beneath that?

It sounds like you want all the answers in 1 cell. If so, why is that? You will not be able to use any of the answers in any future formulas like that. Have you considered putting each calc in it's own cell, instead?

What would some sample answers look like for the other questions, just so I understand what you want