Skip navigation

Calculate hours different employers

189 Views 2 Replies Latest reply: Jan 18, 2013 5:28 AM by Ralph Verdult RSS
Ralph Verdult Calculating status...
Currently Being Moderated
Jan 18, 2013 3:38 AM

Hello,

 

I use Numbers to keep track of the hours I spend for my different employers. It looks like the table below.How do I calculate the total amound of each employer, so I can create a little table like the second table below here, so I can make a pie chart out of that.

 

DateEmployerSubject

Hours

 

01-01-2013A......6
02-01-2013B.....5
03-01-2013C.....4
04-01-2013C.....5
05-01-2013A.....6

 

EmployerTotal hours
A....
B....
C....
D....

 

Regards, Ralph

Mac OS X (10.6.8)
  • Jerrold Green1 Level 7 Level 7 (28,195 points)
    Currently Being Moderated
    Jan 18, 2013 4:12 AM (in response to Ralph Verdult)

    Ralph,

     

    Your situation calls for the SUMIF function.

     

     

    SUMIF

    The SUMIF function returns the sum of a collection of numbers, including only numbers that satisfy a specified condition.

    SUMIF(test-values, condition, sum-values)

    • test-values:  The collection containing the values to be tested. test-values is a

      collection containing any value type.

    • condition:  An expression that results in a logical TRUE or FALSE. condition is an expression that can contain anything as long as the result from comparing condition to a value in test-values can be expressed as a Boolean value of TRUE or FALSE.
    • sum-values:  An optional collection containing the numbers to be summed. sum- values is a collection containing number, date/time, or duration values. It should have the same dimensions as test-values.

     

    Let's say your first table is named "WorkLog". The formulas in the Total Hours column would be:

     

    = SUMIF(WorkLog::B, A, WorkLog::D)

     

    It says: look for rows where the content of WorkLog column B is the same as the content of column A in the table row where this expression is, and add the content of WorkLog column D to the SUM.

     

    Regards,

Actions

More Like This

  • Retrieving data ...

Bookmarked By (0)

Legend

  • This solved my question - 10 points
  • This helped me - 5 points
This site contains user submitted content, comments and opinions and is for informational purposes only. Apple disclaims any and all liability for the acts, omissions and conduct of any third parties in connection with or related to your use of the site. All postings and use of the content on this site are subject to the Apple Support Communities Terms of Use.