IF statements in Excel

[Closed]
Report
-
 Conner -
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!

2 replies

=Count(a1:a9)
3
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2821 users have said thank you to us this month

Posts
261
Registration date
Saturday April 11, 2009
Status
Member
Last seen
June 21, 2011
307
use =COUNTIF(a1:a9,"<>" & "")


--------------------
Winners are losers who got up and gave it one more try. -Dennis DeYoung
Ya, =COUNT wouldn't work here.

COUNTIF gives you the ability to specify what you are counting.

Good luck.

-Conner
http://www.oneclickcommissions.com/excel-statements.html