This formula is working great with 1 exception. If the data in C2:C366 is blank, it causes a #DIV/0 error. What do I add to have the result be "" if C2:C366 is blank for the value "NOV"
Thanks
=SUMIF('Data Daily'!$A$2:$A$366,"NOV",'Data Daily'!$C$2:$C$366)/((COUNTIF('Data Daily'!$A$2:$A$366,"NOV")-COUNTIFS('Data Daily'!$A$2:$A$366,"NOV",
Bookmarks