jimerinbowers
New Member
- Joined
- Oct 19, 2002
- Messages
- 2
If column BB contains "discharge to: info" for patient (i.e., "SNF", "Home", "Expired", etc) and column J contains "age: info" for patient (i.e., "55", "92", "16", etc), what formula (SUM, AVG, etc) do I write that considers only patients' "ages info" who have "expired" (i.e., BB4 contains "expired" and J4 contains "44"; BB7 contains "expired" and J7 contains "17"; etc). I need a formula that compares ONLY LIKE DATA from cells ("expired") in one column (BB, for instance) to data in cells in other columns (J or K or AA, etc) but on the SAME row (4). Probably a standard, elementary question but I am new to this and cannot find the proper "HELP" in the program or other materials at hand. Can you assist? Thank you.