Question
June 8, 2007 at 06:03 AM
cronk005

Excel Question

by cronk005 . Updated 19 years, 4 months ago

I am hoping to come up with a formula, which I have been trying to figure out for some time now.

I have Column A which contains a list of thyroid values. I want to come up with a way of having 3 cells in Column B SUM the patients from Column A based on IF criteria.

A3:A350 – thyroid values
C4 – # of patients hypothyroid (with thyroid values <1.9) C5 - # of patients euthyroid (with thyroid values >1.9 <4.0 ) C6 - # of patients hyperthyroid (with thyroid values >4.0)

I am hoping someone out there might be able to help me create a formula for this situation.

Kind Regards and Thanks in Advanced,

Daniel

This discussion is locked

All Comments