Calculating cells

[Davycc]

Hi guys

I am creating a spreadsheet to record staff sick leave etc (see attached) I have to record full days and half days. I have started to do this recording both full days and half days separately in the totals tab. However it would be great if instead of the 2 separate columns in the totals half days automatically added to the one total ie 1 full day and 3 half days recorded as 2.5.

any help would be appreciated.

David

[oeldere]

Englisch=countif(B5:AF5,"F")*1+countif(B5:AF5,"FH")*0,5

See cell AH4

[Davycc]

oeldere, thank you very much, so simple when you know how.

thankyou again.

[Davycc]

This only seems to change when I exit the spread sheet, it does not change no matter how much data I enter but when I close the sheet it all changes then closes. Or if I save the sheet.

[oeldere]

Glad I could help.

Please mark the question solved, if it is solved.

You can add points to the rep(utation) of a member by clicking on the star (add reputation) add the left side of the window.

[Davycc]

Hi I was about to do that then I discovered the above glitch. I certainly will add to the rep as this has helped me greatly.

[oeldere]

@Davycc

You don't add your excel version.

In excel 2013 it is

formula => countoptions => automatic.

Problably you default is manual.

[Davycc]

That's exactly what it was, cheers.

Great job.

[oeldere]

Thanks again for the help, how do I mark the thread as solved?

Above your first question (#1) there is a button which allow you to mark the threat solved.