Hello all...
I have this formula, I am using to calculate the number of entries by a customer per month... I would like it to leave the cell blank if there were no entries (zero). I would greatly appreciate your help. Thank you.
=COUNTIFS('ECN LIST'!$B:$B,$AK$16,'ECN LIST'!$C:$C,$AS$15,'ECN LIST'!$E:$E,">="&$AN16,'ECN LIST'!$E:$E,"<="&EOMONTH($AN16,0))
Bookmarks