Hello All, I am re-doing an old worksheet of a colleagues and came across a few lines I do not quite understand. I was hoping someone could help explain in words what this means:
Data is a sheet I am pulling data from.
Please Login or Register to view this content.
See https://support.office.com/en-ie/art...8-f7c5c3001690
A little confusing in that AVERAGIFS has the average range first with the conditions following and AVERAGEIF has the ONLY condition first and the average range second.
The IFERROR will return a zero ( 0 ) if the function returns an error.
I suspect that the values in column G are dates, so maybe the formulae are producing values for a date range, maybe a month.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks