hi,

Im using the formula
=countifs(a6:a705,isblank(false),e6:e705,isblank(f alse)
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?