Forum Discussion
Help with COUNTIF
I have included a picture of what my database looks like for reference. This database tracks patients hemoglobin results and categorizes them into 3 different categories down at the bottom ...
=LET(Hgb,
IF(K2:K121<>"",K2:K121,E2:E121),
SUM((Hgb>=10)*(Hgb<=12))
)
If you work with Office 365 or Excel for the web you can apply this formula. In the first step the formula selects the most recent draw for each row and then it counts the instances >=10 and <=12.