All,

Can someone advise me on this formula:


=IFERROR(AVERAGEIF(AE4:AZ4,1,E4:Z4),"")


How can you embed an ABS function in there? You cannot put it in here abs(E4:Z4) you will get error on the formula.


appreciate any inputs.