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?

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

" wrote:

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?

Hi

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

--
Regards
Roger Govier

wrote in message
...
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?