I am trying to avoid the divide by 0 error when doing a sum product formula. All criteria involved has blanks. I know that sumproduct turns blanks into 0's. I just want to to avoid that issue. I used this formula among others: =SUMPRODUCT(ISNUMBER(B2:B6/A2:A6)*1)/COUNTA(B2:B6)-1. The base formula is=SUMPRODUCT(B2:B6/A2:A6)/COUNTA(B2:B6)-1. See attached file.
Bookmarks