Hi and thanks in advance.
I have a cell with a formula which displays the number of used rows on a sheet.
I have another cell with a formula on the same sheet which displays "OK" if all the values in columns Q and U are TRUE, or "OUT" if FALSE ...
=IF(COUNTIF($Q$12:$Q$865, TRUE) + COUNTIF($U$12:$U$865, TRUE) = $H$4*2, "OK", "OUT")
At the moment the ranges in the two COUNTIFs are static coded from row 12 to 865. I would like to replace the 865 with the value in the cell which displays the total number of used rows on the sheet. Is there a way to insert this dynamic value into the formula?
Regards
Deutz
Bookmarks