I have a summary page with data in rows. Within that row I want the
average of all the numbers that have a specific value in the cell
before it.
For instance:
3 3500 3 3500 7 4000 7 4000 28 5000 28
I want the average of all the numbers with 7 before it or 4000. I
have 10 sets of data to shearch from.

Do I need a vba program to do this?