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.

Surface Pro (2017) vs Surface Pro 4

20 groundbreaking 3D animation technologies coming to Siggraph 2017

iPad Pro 12.9 vs Surface Pro 5