Sumif on pulling out data from dates

E

Eagleryder

I have a data rage that column A is employee name, column B is date that the
employee worked, and Column C is the hours worked on that day. Their are
additional columns that calulate overtime. On a separate Sheet i have an
overveiw of this and other data. I want to do a sumif that will pull all of
the hours from a given month and total them up on the overview page.
 
E

Eagleryder

Thank you it worked like a charm.

T. Valko said:
One way...

To sum hours for Jan 2008:

=SUMPRODUCT(--(TEXT(Sheet1!B2:B20,"mmm/yyyy")="Jan/2008"),Sheet1!C2:C20)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top