Adding up general numbers

[timboellis]

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 Blank, Friday Blank, 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 blank the person has not entered any info on this so with effect they have 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?

 

[just_jon]

Book1.xls
	A	B	C	D	E	F	G	H	I
1	Mon	Tues	Wed	Thur	Fri	Sat	Sun	Hrs Worked	Days Worked
2	8	12		6		2		28	4
Sheet3

 

[Crow_23]

If the #s are in a column of there own you could just go to the very last row and do a =Sum(B2:B10) or however many rows there are.

 

[timboellis]

Spot on cheers for that