Thread: if sum
View Single Post
  #3   Report Post  
Bob Phillips
 
Posts: n/a
Default

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