MacMost Q&A Forum • View All Forum QuestionsAsk a Question

Numbers – How To Collect a Summary Of Days Via a Lookup Function?

So in the screenshot attached here. I would like to collect all working hours that belong to a month into a single cell.

soo I want to search for a certain year-month and collect those dates and summaries those in a single cell belonging to a month.

I’m not sure where to start. From some videos it seems like i need the lookup function but i can’t understand the rest i’m afraid, some help is appreciated!



Comments: 3 Responses to “Numbers – How To Collect a Summary Of Days Via a Lookup Function?”

    6 years ago

    No, the LOOKUP function is for something else. For instance, if you had two tables, one that is a list of prices for products and the other that is a list of purchases. The second table can look up the price of the product in the first table. So you put "apple" into the product and another cell fills in $0.23 from the first table.

    What you want is SUMIFS. This will take the values in one column and add them together if the values in other columns meet your conditions.

    So if column A is the date, and column B is the number of hours, then a formula like =SUMIFS(B,A,">=4/1/2018",A,"<5/1/2018") will give you want you want. It takes the values from column B and adds them up. But only if the date in column A is first greater than or equal to April 1 at midnight and then if it is also less than May 1 at midnight.

    Look up the SUMIFS function in the functions help text and read it all very carefully. Also, I would put this formula in another table. So the first table is just a list of dates and hours. The second table is then your calculations. So when entering the formula, click the column heading instead of typing in "B" or "A" so it puts the proper value in there. It should look like Table 1::A or something similar.

    See Using the Numbers SUMIF Function which talks about the SUMIF function and note that SUMIFS is slightly different as the parameters are in a different order.

    Lali Raj
    6 years ago

    Numbers is as powerful as excel in all consideration?

    6 years ago

    Lali: Not sure what you are asking. Excel and Numbers are both basically spreadsheets. Excel has more powerful advanced math and data features, but 95% don't need those. Numbers has more advanced design features (multiple tables per sheet). SO they are different.

Comments Closed.