formula is not working

[mulji.hafeez]

hi,

Im using the formula
=countifs(a6:a705,isblank(false),e6:e705,isblank(false)
I need to tally up the amount of rows where both criteria match.

The only problem is that all the cells in those ranges have formulas.

=countifs does not tally up the total because there are formulas
within those cells.
Is there any other way I can do this where I can ignore the formulas
in the cells and just find out if there are values or not?

 

[Sheeloo]

Try
=SUMPRODUCT(--(A6:A705<>""),--(E6:E705<>""))

 

[Roger Govier]

Hi

try
=COUNTIFS(A6:A705,"<>",E6:E705,"<>")