Using this formula: =IFERROR(AVERAGEIFS(C7:AL7,C3:AL3,"Sales",C7:AL7,">0"),"")*12
I get this error message: #VALUE! anyway to stop it when the cell is blank?
Using this formula: =IFERROR(AVERAGEIFS(C7:AL7,C3:AL3,"Sales",C7:AL7,">0"),"")*12
I get this error message: #VALUE! anyway to stop it when the cell is blank?
Maybe move *12 to inside the formula?
=IFERROR(AVERAGEIFS(C7:AL7,C3:AL3,"Sales",C7:AL7,">0")*12,"")
Put the *12 inside the IFERROR.Formula:Please Login or Register to view this content.
If posting code please use code tags, see here.
Yes that worked, Thank you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks