Thanks Riny, I thought that was the case, just wanted confirmation
Thank you Saliha.
Thanks Riny
Hi Velouria, I have attached an updated the attached sheet, When I add in all other services the old formula (cell C185) returns an average of a...
Thanks Velouria, I'm away at the moment, let me try this when I get back, will confirm all OK the, Regards Paul
Thanks Riny & Velouria @Velouria: the formula works but gives me the average of all 2382 rows, I need to know the average for each of the ...
Thanks for your help, all sorted now. Regards Paul
Hi The data for Ibis Swansea on row 70 on the 'Sites & Groups' tab, should be feeding through to the 3 tables on the 'Report' tab, but 'Ibis Sw...
Thank you, Riny, I did not know you could use SUMIFS for this type of query, you never stop learning. Regards Paul
Thank you so much for your help Catalin, Sorted, I would not of thought of that solution, Regards Paul