Thread: Average function for letters
View Single Post
  #4   Report Post  
ZWarren ZWarren is offline
Junior Member
  
Posts: 2
Default
Quote:
Originally Posted by Spencer101 View Post
Quick and dirty, but it works :)

=COUNTA(A4:A24)/SUM(COUNTA(A4:A24)+COUNTBLANK(A4:A24))

Format the cell as %.
This worked, I appreciate it!
Reply With QuoteReply With Quote