# Making Average() formula ignore months with too much blanks

1. ## Making Average() formula ignore months with too much blanks

Hello everyone, I trying to make my Average() array formula ignore months, which have more than 5 blanks to simply ignore it, does anyone have a clue how to do this?
In the example that I show you, the second month should be excluded, because the values in column R have too much blank cells in that month.

P.S.
If using the blanks is too difficult, values in column N below 5 would respond in the same way (if there more than 5 cells with values less than "5").

2. ## Re: Making Average() formula ignore months with too much blanks

Try this...

Entered in S2 and copied down:

=IF(COUNTIFS(A\$2:A\$42,">="&T2,A\$2:A\$42,"<="&EOMONTH(T2,0),R\$2:R\$42,"")>5,"",AVERAGEIFS(R\$2:R\$42,A\$2:A\$42,">="&T2,A\$2:A\$42,"<="&EOMONTH(T2,0))*10^4)

Thank you.

4. ## Re: Making Average() formula ignore months with too much blanks

You're welcome!

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1