how do you add up alpha???

M

muttley23

I have set up a holiday planner to add up holiday entitlement, etc and have
put in box SL when they have a day off sick. How can add this to my
running holiday or get to add up???
 
R

Ron Coderre

Just a guess....

For values in A2:AE2

This formula counts the occurrences of "SL" in that range:
AF: =COUNTIF(A2:AE2,"SL")

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro
 
Top