Good afternoon,
I just have to work out average commission per category by the company based on Base company.
I do not have numbers on every cell and I want excel to calculate if there is the number in the cell /number in the Base company.
Please see attached excel and green cell for what I would like to achieve.
Thank you so much in advance.
Regards,
Aye
Hi Aye
Can't download your attachment.
Getting a 400 Bad Request error.
Can you upload the file again?
The filename has a % in it which is probably causing the 400 error.
Aye - please make sure the filename consists of just letters/numbers
Phil
Hi Phil,
Many thanks for getting back to me.
Please see attached file.
You can use:
=AVERAGE(IF(C3:V3<>"",(C3:V3-$C$2:$V$2)/$C$2:$V$2,""))
array-entered with Ctrl+Shift+Enter, then copied down.
Hi Velouria,
Thank you so much for the formula. Much appreciated.
It is a very useful one for me.
Regards,
Aye
