LinkBack URL
About LinkBacks
Is there an Aggregate function to get an Average of A1:A99 for example that will ignore 0's and Hidden Rows. I can get it to work just ignoring Hidden Rows but can't figure out how to Ignore 0's
=AGGREGATE(1,7,G4:G103) - Here's what I have now
Is there an Aggregate function to get an Average of A1:A99 for example that will ignore 0's and Hidden Rows. I can get it to work just ignoring Hidden Rows but can't figure out how to Ignore 0's
=AGGREGATE(1,7,G4:G103) - Here's what I have now
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks