I have two sets of data in two columns I am running reports and averages on, a pretest and posttest.
A few of these sets do not have complete data.
What I want to do is exclude the results if the data is not complete for that test. Example data below has two data sets that are not complete and need to be removed from the results.
If I were to run this count I only want to be able to show completed tests for pretest:
=COUNTIF(K:K,"<=1.9")
The desired result would be 7. How could I build the formula to exclude results with missing data? I hope I am explaining this right. Thanks
PRETEST POSTTEST
1.2 2.7
1.4 2.9
1.5 3
1.7 0.9
1.9 1.6
1.9
1.9 1.9
1.9 4.5
2.2
2.3 3.5
2.3 3.9
Bookmarks