Forum Discussion
Solved
Nesting IFERROR inside AVERAGEIFS
I made this formula: =AVERAGEIFS(AM:AM,B:B,AH1) The problem is that there are cells within column AM that have #VALUE because at this time, the data is incomplete. This is a living document, so...
=SUM(IF((NOT(ISERROR(AM:AM)))*(B:B=AH1),AM:AM))/SUM((B:B=AH1)*(NOT(ISERROR(AM:AM))))You can try this formula. Enter the formula with ctrl+shift+enter if you don't work with Office 365 or Excel 2021.
=SUM(IF((NOT(ISERROR(AM:AM)))*(B:B=AH1),AM:AM))/SUM((B:B=AH1)*(NOT(ISERROR(AM:AM))))You can try this formula. Enter the formula with ctrl+shift+enter if you don't work with Office 365 or Excel 2021.
Perfect! Thanks so much.