Hi,

I am trying to be more efficient with my countif functions. I have 5 regions on a sheet that i want a formula to count how many times 'UNVAILABLE' and 'VACANT' are in the 5 regions, then subtract that number from 39. So the formula i have at the moment is 

=39-(COUNTIF(B8:B14,"VACANT"))-(COUNTIF(B16:B25,"VACANT"))-(COUNTIF(I8:I14,"VACANT"))-(COUNTIF(I16:I24,"VACANT"))-(COUNTIF(P8:P13,"VACANT"))-(COUNTIF(B8:B14,"UNAVAILABLE"))-(COUNTIF(B16:B25,"UNAVAILABLE"))-(COUNTIF(I8:I14,"UNAVAILABLE"))-(COUNTIF(I16:I24,"UNAVAILABLE"))-(COUNTIF(P8:P13,"UNAVAILABLE"))
Can anyone help top condense the forumla?

Thanks,
Mark