LinkBack URL
About LinkBacks
Maybe this...
=SUM(SUMIF(C:C,{"July","August","September"},D:D))/SUM(COUNTIF(C:C,{"July","August","September"}))
Maybe this...
=SUM(SUMIF(C:C,{"July","August","September"},D:D))/SUM(COUNTIF(C:C,{"July","August","September"}))
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
That is the ticket! Thank you very much, Mr. Valko
You're welcome. Thanks for the feedback!
If your question has been solved please mark the thread as being solved.
In the menu bar above the very first post select Thread Tools, then select Mark this thread as solved.
Oops! Hmm. Mr. Valko, the formula is giving me a DIV/0 Error because there are blank cells. Is there a work-around for that?
Empty cells should not cause an error unless ALL of the cells are empty.
You'll get the #DIV/0! error if the COUNTIF = 0.
You could get an incorrect result if cells in column D are empty but the corresponding cells in column C contain one of the criteria months.
Which column has the empty cells?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks