Excel help please

  Taurus 13:16 03 Jan 09
Locked

Happy New Year to all!

I have created a spreadsheet in Excel 2003 that contains a column of hours relating to time absent (from work). There are three possible reasons for the absence, Sickness, Holiday and Study Time. The column, by nessecity gives a total for the entire hours but I need to extract one set of hours from the list, that is holiday hours, to enable entitlement calculations. An adjacent column contains a code describing the type of absence, S for sickness L for holiday and SD for study if this helps.

I would be grateful for some help on how to achieve this.

  VoG II 13:21 03 Jan 09

With hours in column A and reason code in column B

=SUMIF(B1:B100,"S",A1:A100)

gives total hours for Sickness.

  Taurus 13:25 03 Jan 09

Many thanks VoG™, happy new year to you and yours.

This thread is now locked and can not be replied to.

Nintendo Switch review: Hands-on with the intuitive modular console and its disappointing games…

1995-2015: How technology has changed the world in 20 years

This abstract video touches on division in our technologic world

Best alternatives to iTunes for Mac | Best music players for macOS: Free your music from the…