IF statements in Excel
Closed
Hello,
I'm looking for some help with conditional coding in excel. If text is entered in one of eight specified cells, then I would like 1 added to a "total" cell. It is being used to track total number of patients present at a given time.
For example, if patient names are entered in cells a1, a5 and a9, then a40 would give a value of 3. If no names were entered in the specified cells, a40 would show a value of 0.
Any ideas? I know generally how to use IF and THEN statements, but this is a bit over my head...
Thanks in advance for your help!
I'm looking for some help with conditional coding in excel. If text is entered in one of eight specified cells, then I would like 1 added to a "total" cell. It is being used to track total number of patients present at a given time.
For example, if patient names are entered in cells a1, a5 and a9, then a40 would give a value of 3. If no names were entered in the specified cells, a40 would show a value of 0.
Any ideas? I know generally how to use IF and THEN statements, but this is a bit over my head...
Thanks in advance for your help!
Related:
- IF statements in Excel
- Number to words in excel - Guide
- Gif in excel - Guide
- Excel mod apk for pc - Download - Spreadsheets
- Marksheet in excel - Guide
- How many nested if statements in excel - Guide
2 responses
Excelguru
Posts
261
Registration date
Saturday April 11, 2009
Status
Member
Last seen
June 21, 2011
307
May 14, 2009 at 11:40 PM
May 14, 2009 at 11:40 PM
use =COUNTIF(a1:a9,"<>" & "")
--------------------
Winners are losers who got up and gave it one more try. -Dennis DeYoung
--------------------
Winners are losers who got up and gave it one more try. -Dennis DeYoung