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!
Configuration: Windows XP Internet Explorer 6.0
Conditional formatting with if statements in excel Creating if statements in excel using between Excel for mac if a cell contains a letter conditional formatting Excel formula if else Excel visual basic if statement value of cell How do i open an excel file if i don't have excel How to copyabd paste an if statement in excel How to make excel cell change color if How to make excel if statement if negative to convert to positive How to retrieve my rediffmail password if i forgot the security question If any cell change content then excel If cell color excel formaulas If formula excel 2007 If statement if cell equals list Macro excel to check if value is already there Nested if function tables excel 2007 Show "f" if e2<50-excel Using multiple if then statements excel