Simple IF function

[Hubertus C]

Hi all,

I'm get a sheet every month with the hours that my employees worked.
Now, I want a sheet to summarize the first sheet. This is (part of) the sheet with all the information that I want to use:

Capture.PNG
Attachment 481760
It needs to check if Column F in the sheet2 above (the name) is the same is as in cell B4 (for example, see attachment below) in sheet 1. If the result is True, then it needs to add column H (the hours worked on 1 day) and add this value to the corresponding month in Sheet1. But all hours of that month, from a certain employee need to come in that cell.

Capture2.PNG
Attachment 481763

Does anyone know how to do this? If you need more explanation, please tell me!

Thanks for the help!

[NBVC]

In Sheet2, add a helper column say, in column I that extracts the month name from teh date in column G... use formula in I2: =TEXT(G2,"mmmm") copied down

Then in Sheet1, C3 use SUMIFS formula

eg. =SUMIFS(Sheet2!$H:$H,Sheet2!$F:$F,$B3,Sheet2!$I:$I,C$2)

copied down and across.

[Hubertus C]

Thanks for the help!

I just don't get how I can check if the date (1-aug for example) is in the month August? I can't change the date field. Any idea?

[NBVC]

Did you see the part where I said to add the Helper column in I. That extracts the month name, e.g. AUGUST

[Hubertus C]

Yes, I did, but I get an error when I use it:

23lgikh.png

And I don't understand why, I used your formula:

jph9wz.png
http://i66.tinypic.com/23lgikh.jpg
http://i64.tinypic.com/jph9wz.png

[Hubertus C]

Got it, I know use:
=MONTH(G5763)

Thanks a lot NBVC!

[NBVC]

does your excel use semicolon ; as separator?