I have a sheet where i have Mon, Tues, wed/etc.
On these days I have a list that incudes a number could be anything from 1-100.
So if someone enters say Monday 20, Tuesday 56, Wednesday 9, Thursday 0, Friday 0, Saturday 2, Sunday 23
How to a get a field at the end of this to say this person has worked for x amount of days .
In this case it would be 5 days as the ones that say 0 the person has not worked that day.
So in short how to you add the numbers up, what ever the number as 1 and then **** all these up to work out how many days that person was in for
Does this make sense?
On these days I have a list that incudes a number could be anything from 1-100.
So if someone enters say Monday 20, Tuesday 56, Wednesday 9, Thursday 0, Friday 0, Saturday 2, Sunday 23
How to a get a field at the end of this to say this person has worked for x amount of days .
In this case it would be 5 days as the ones that say 0 the person has not worked that day.
So in short how to you add the numbers up, what ever the number as 1 and then **** all these up to work out how many days that person was in for
Does this make sense?
