COUNT IF formula

[aaron85w]

Hi Everyone, I am working on a team work calendar and need to count the number of days a resource is available.

The easiest way to explain is as follows:

The formula needs to check cells D6:G6,J6:N6,Q6:U6,X6:AB6,AE6:AH6 and only count the number of blank cells and output this number in cell AI6.

Any help would be great.

Cheers

[Tony Valko]

Not a real elegant way to do this.

=SUM(COUNTIF(INDIRECT({"D6:G6","J6:N6","Q6:U6","X6:AB6","AE6:AH6"}),""))

=COUNTIF(D6:G6,"")+COUNTIF(J6:N6,"")+COUNTIF(Q6:U6,"")+COUNTIF(X6:AB6,"")+COUNTIF(AE6:AH6,"")

[Rob.Marchel]

Hi Aaron,

=SUM(COUNTIF(D6:G6,""),COUNTIF(J6:N6,""),COUNTIF(Q6:U6,""),COUNTIF(X6:AB6,""),Countif(AE6:AH6,""))

That should do the trick?

Rob

[Danerida]

=countblank(d6:g6)+countblank(j6:n6)+countblank(q6:u6)+countblank(x6:ab6)+countblank(ae6:ah6)

[aaron85w]

Thanks all, works a treat!

Much appreciated

[Tony Valko]

You're welcome. We appreciate the feedback!