Hello,
I'm creating a weighted average formula with data that has random blank cells. I have been using the SUMPRODUCT approach (the best option?) but my formula counts the blank cells. I attached a super-simple workbook to highlight my issue.
I greatly appreciate any help.
Bookmarks