cell is blank then dont count range
 

Hi

This seems to be simple in my head but cant work it out!, in my speadsheet i
want to count f3 & a3 which is easy but if f3 is blank then i dont want to
count any cells

any help would be great!!

cell is blank then dont count range
 

Try

=IF(F3="","",F3+A3)

Mike

"james b" wrote:

Hi

This seems to be simple in my head but cant work it out!, in my speadsheet i
want to count f3 & a3 which is easy but if f3 is blank then i dont want to
count any cells

any help would be great!!

cell is blank then dont count range
 

Hi Mike

i have tried that but still havinga problem, let me explan a bit better,

i want to be able to count the cells that are not empty in a range
(h3,f3,b3) but if the 1st cell i choose (h3) is blank then dont count the
rest of the cells

also if h3 is not empty but f3 is empty and b3 is also not empty then the
number i want is 1

iam trying to set up action plans, i have 5 stages so if a member of staff
fails to hit target each month then they go onto which number stage there are
at but if they hit there target 1 month then the action plans revert back to
stage 1.

1 = grace month
2 = action plan
3 = verbal warning
4 = written warning
5 = final warning

i have already sorted the lookup so that not a problem

hope thats abit clearer

james


"Mike H" wrote:

Try

=IF(F3="","",F3+A3)

Mike

"james b" wrote:

Hi

This seems to be simple in my head but cant work it out!, in my speadsheet i
want to count f3 & a3 which is easy but if f3 is blank then i dont want to
count any cells

any help would be great!!

cell is blank then dont count range
 

Hi mike

all sorted so thanks for your help!!!!

"Mike H" wrote:

Try

=IF(F3="","",F3+A3)

Mike

"james b" wrote:

Hi

This seems to be simple in my head but cant work it out!, in my speadsheet i
want to count f3 & a3 which is easy but if f3 is blank then i dont want to
count any cells

any help would be great!!