calculating average in interval

[pani_hcu]

Hi All,

I am trying to write a macro where i want to calculate average in different columns (with specific intervals). Is it possible to write macro at the end of the of each row.

I have attached the workbook for the same. I have highlighted the rows where i want to calculate the average.

With sincere regards,
Upananda

[venkat1926]

requirement is not clear
nothing has been highlighted.
when you send a workbook to somebody dont highlight (when the receiver selects any other cell by mistake the original highlight goes off), but color it.
which sheet data is relevant .
give at least one example of row average obtained manually.

[arthurbr]

Is this what you mean ? =AVERAGE(D3;F3;H3;J3;L3;P3;R3) (replace; with , if needed)