Count is 1,2,3,...
Sum is adding every value you like, including halves.
I keep an attendance spreadsheet for my office.
I use the COUNTIF function to calculate vacation, personal days etc. The one thing I need to do is calculate half days (.5)
Does anyone know of a formula I can use.
I have an example of my sheet if it will help you.
I need ASAP.
Any help will be appreciated.