LinkBack URL
About LinkBacks
mahat 
You are correct, I had all empty cells in one section. Much appreciated.
You are correct, I had all empty cells in one section. Much appreciated.
Ok, you can prevent the #DIV/0! error with this version:
=IFERROR(SUM(SUMIF(C:C,{"July","August","September"},D:D))/SUM(COUNTIF(C:C,{"July","August","September"})),"")
That'll return a blank instead of any errors.
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks