Hello, quick question please could you tell me how to average a range if range not blank. If range is blank then I would like to return a blank.
many thanks,
A
Hello, quick question please could you tell me how to average a range if range not blank. If range is blank then I would like to return a blank.
many thanks,
A
You could do something like thisFormula:
Please Login or Register to view this content.
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
Or maybe:
![]()
Please Login or Register to view this content.
Willem
English is not my native language sorry for errors
Please correct me if I'm completely wrong
Many thanks, both.
A
And a follow up question if I may. I am averaging a range that is populated via index match. the formula I am using is an array like this:
=IFNA(INDEX(J10:J13,MATCH($A$13:$A$16,$H$10:$H$13,0)),"")
How do I prevent the average function I am using (thanks Willem) calculating on the blank "". At present it is counting the empty cells as 0.
Many thanks,
A
Hi Adame,
To ignore 0 (zero), try: =IF(COUNT(A1:A10)=0,"",AVERAGEIF(A1:A10,"<>0"))
If your Question is answered; please mark it SOLVED. If you are happy with a member's solution, say 'Thanks' and click the 'Star' to Add Reputation.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks