IF Cell is blank, use COUNTA formula.

[Henrybukowski]

Hi Folks,

Excuse my stupidity, I have a fairly straightforward excel formula question.

I am trying to use the following formula:

=IF(ISBLANK('Contract Compliance Month 3'!F38:F39),COUNTA('Data Sheet'!D7:D64))

if a certain cell, F38:F39 is filled, run the counta formula and display the total. If the cell F38:F39 is blank,and therefore the data incomplete, don't display anything.

However, when I wrote this formula in it displays the total regardless of whether cell F38 is blank or not

Could anybody point me in the right direction?

Many thanks.

 

[BrianMH]

=IF(COUNTBLANK('Contract Compliance Month 3'!F38:F39)=0,COUNTA('Data Sheet'!D7:D64),"")