Hi
Can you please add an example workbook so we don’t need to recreate the data.

Maybe a little bit more explaining the issue as well might help

Purfleet

Hi Jihad Saleh Alhalabi, welcome to Mynda's Forum!

Since you are already using the average function in row 3 and you seem to want the outcome of your question in Q2, why don't you use there '=P3+1'?

Frans

Hi Frans Visser

I feel your suggestion is not suitable and won't solve the problem.

Hi Purfleet

I have attached my excel file

Thanks a lot

Hi Jihad,

Welcome, please read this

https://www.myonlinetraininghub.com/excel-forum/forum-rules-and-guides/read-this-first

As Purfleet said, can you please add a clear explanation of what you are trying to achieve.  I do not understand what you mean by adding 1 to the average?

Why is Frans answer not suitable? 

Regards

Phil

Hello,

The needed formula in cell Q2 is

=(P$3+1)*COLUMNS($B$2:Q$2)-SUM($B$2:P$2)

Br,
Anders