Hi again
I'm looking for your help again, Its hopefully a easy fix.
The attached is a sample holiday form what i would like is a formula which will add up, per staff member not just the holiday days (input as 1.0) but also sick days (input as S) and training days (input as T).
Thanks in advance
Sue
Use
=COUNTIF(C3:AG3,"S")
for sick
And
=COUNTIF(C3:AG3,"T")
for training
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Put this formula in AI3 to count the Sick days:
=COUNTIF(C3:AG3,"S")
and this in AJ3 to count the Training days:
=COUNTIF(C3:AG3,"T")
Then copy both formulae down.
Hope this helps.
Pete
Thank
That does the job grand
your welcome and thanks for the rep
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks