Hello,
I currently have the formula
=SUMPRODUCT(1/COUNTIF(A2:A7,A2:A7)) which produces the correct result I want, 3.
However, I will need to keep the range A2:A11 open as each month, the data within this range will vary.
Changing the formula to =SUMPRODUCT(1/COUNTIF(A2:A11,A2:A11)) produces a DIV/0! error as cells A8 - A11 are blank.
Is there something I can change to my formula with range A2:A11 to exclude and not count blanks?
Thanks in advance!
Snip.jpg
Bookmarks