Question

Locked

Excel Question

By cronk005 ·
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 conversation is currently closed to new comments.

2 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Answers

Collapse -

"scratchpad" hidden columns

by Churdoo In reply to Excel Question

One method is, create 3 columns off to the side, with IF statements to distribute the A cells into their corresponding categories. Syntax below may not be exact, so bear with me.

For example,
AA3:(IF($A3<1.9,$A3));
AB3:(IF($A3>=1.9 AND $A3<4,$A3));
AC3:(IF($A3>4,$A3))
Fill these cells from rows 3 to 350.

This will create 3 columns in AA3:AA350 through AC3:AC350, distributing the thyroid values into the 3 respective ranges, then your counts can be:
C4:(=COUNT(AA$3:AA$350));
C5:(=COUNT(AB$3:AB$350));
C6:(=COUNT(AC$3:AC$350))

There may be a direct way to do it, but creating the out-of-view scratchpad area is a method of breaking the problem down to manageable steps.
--C

Back to Software Forum
2 total posts (Page 1 of 1)  

Related Discussions

Related Forums