if sum
 

My Worksheet has columns with names of employees, check dates and check
amounts, Im looking for a formula to add up all the earnings for a specific
employee for a specific month. This is an example of my Worksheet:

Name Date Gross Pay.
Employee # 1 06-Jan-05 $ 800.39
Employee # 1 13-Jan-05 $ 727.51
Employee # 1 20-Jan-05 $ 752.38
Employee # 1 27-Jan-05 $ 654.39
Employee # 1 03-Feb-05 $ 744.58
Employee # 1 10-Feb-05 $ 717.03
Employee # 1 17-Feb-05 $ 704.11
Employee # 2 06-Jan-05 $ 324.89
Employee # 2 13-Jan-05 $ 407.34
Employee # 2 20-Jan-05 $ 289.16
Employee # 2 27-Jan-05 $ 404.87
Employee # 2 03-Feb-05 $ 363.66
Employee # 2 10-Feb-05 $ 374.30
Employee # 2 17-Feb-05 $ 356.85
Thank you

This question has been answered for you at least twice now.

quoting from a reply to one of your earlier messages

=sumproduct(--(a1:A100="Employee x"),--(month(b1:b100)=4),c1:c100)
where column a= employee name
column b = dates (in the above example april)
column c = check amounts


"rb" wrote:

My Worksheet has columns with names of employees, check dates and check
amounts, Im looking for a formula to add up all the earnings for a specific
employee for a specific month. This is an example of my Worksheet:

Name Date Gross Pay.
Employee # 1 06-Jan-05 $ 800.39
Employee # 1 13-Jan-05 $ 727.51
Employee # 1 20-Jan-05 $ 752.38
Employee # 1 27-Jan-05 $ 654.39
Employee # 1 03-Feb-05 $ 744.58
Employee # 1 10-Feb-05 $ 717.03
Employee # 1 17-Feb-05 $ 704.11
Employee # 2 06-Jan-05 $ 324.89
Employee # 2 13-Jan-05 $ 407.34
Employee # 2 20-Jan-05 $ 289.16
Employee # 2 27-Jan-05 $ 404.87
Employee # 2 03-Feb-05 $ 363.66
Employee # 2 10-Feb-05 $ 374.30
Employee # 2 17-Feb-05 $ 356.85
Thank you

How many times are you going to ask this question before you read one of the
previous replies?

--

HTH

RP
(remove nothere from the email address if mailing direct)


"rb" wrote in message
...
My Worksheet has columns with names of employees, check dates and check
amounts, I'm looking for a formula to add up all the earnings for a
specific
employee for a specific month. This is an example of my Worksheet:

Name Date Gross Pay.
Employee # 1 06-Jan-05 $ 800.39
Employee # 1 13-Jan-05 $ 727.51
Employee # 1 20-Jan-05 $ 752.38
Employee # 1 27-Jan-05 $ 654.39
Employee # 1 03-Feb-05 $ 744.58
Employee # 1 10-Feb-05 $ 717.03
Employee # 1 17-Feb-05 $ 704.11
Employee # 2 06-Jan-05 $ 324.89
Employee # 2 13-Jan-05 $ 407.34
Employee # 2 20-Jan-05 $ 289.16
Employee # 2 27-Jan-05 $ 404.87
Employee # 2 03-Feb-05 $ 363.66
Employee # 2 10-Feb-05 $ 374.30
Employee # 2 17-Feb-05 $ 356.85
Thank you