Excel help please

  Taurus 13:16 03 Jan 2009
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 2009

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 2009

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

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

Elsewhere on IDG sites

WPA2 hack: How secure is your Wi-Fi?

Add Depth Of Field to a photo using Tilt Shift Blur in Photoshop

iPhone tips & tricks

Comment afficher des fichiers cachés sur Mac ?