Sumif on pulling out data from dates
 

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.

Sumif on pulling out data from dates
 

One way...

To sum hours for Jan 2008:

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


--
Biff
Microsoft Excel MVP


"Eagleryder" wrote in message
...
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.

Sumif on pulling out data from dates
 

Thank you it worked like a charm.

"T. Valko" wrote:

One way...

To sum hours for Jan 2008:

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


--
Biff
Microsoft Excel MVP


"Eagleryder" wrote in message
...
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.

Sumif on pulling out data from dates
 

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"Eagleryder" wrote in message
...
Thank you it worked like a charm.

"T. Valko" wrote:

One way...

To sum hours for Jan 2008:

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


--
Biff
Microsoft Excel MVP


"Eagleryder" wrote in message
...
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.