=SUMPRODUCT(IFERROR(F5:F10000,0),IFERROR(I5:I10000,0))
After typing in the formula (but still editing it), press CTRL-SHIFT-ENTER so that Excel treats it as an array formula.
=SUMPRODUCT(IFERROR(F5:F10000,0),IFERROR(I5:I10000,0))
After typing in the formula (but still editing it), press CTRL-SHIFT-ENTER so that Excel treats it as an array formula.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks