Excel 2007 : Formula to find a letter then add a value

[Benny Allen]

This is my first time using this website, so please forgive my inexperience with Excel and any daft questions I have.

I am trying to create a spreadsheet to manage employee time worked. It will record hours worked, plus any days (or portions of days) taken for different types of leave.

My problem is that I don't know what type of formula in C62 to use to say "if there's an 'S' in cell C8, then add value in D8; and If there's an 'S' in C9, then add value in D9, and so on, so that I eventually get a total of all sick days that employee 1 has taken in the month, i.e. 2 .

Because there will always be the need to record, say, a half day worked and a half day's holiday, I have left 2 cells available for each date, one to record W (hours worked) and one for all other variables.

If anyone knows what type of formala I should be using to work this out, I would extremely grateful. I'm a bit of a novice when it comes to any formulae past simple SUM etc!

I will be using a tab for each month, and link the totals into future months. Think this should be easy enough to work out.

[zbor]

Wellcome Benny,

please rename your title according to the rules:

1. Use concise, accurate thread titles. Your post title should describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

To change the title of the thread, click EDIT on the original post, then click the Go Advanced button, then change the title. If two or more hours have passed, the EDIT button will not appear, and you need to ask a moderator to change the title.