Sign in to join the conversation:
Hi everyone!
I have several projects in my time tracking sheet and would like to use the VLOOKUP formula to save only the times per project in a monthly cost table. For that I used the following formula:
=VLOOKUP([Project Number]12, {Sheet - Time Tracker (10-October) Range 1}, 8, false).
Unfortunately, I only got one labor cost entry (for project number 9150), although there are two more (see screenshot attached).
Does anyone know how to get the sum of the costs (sortetd by project number) through this formula? The entries are made via Web Form and so all working hours of all projects are in one table. Do I have to create an individual time tracking sheet and web form for each project? Would be awkward, doesn´t it?
Would be great if someone has an idea how I could solve this a little more elegant.
Thanks!
Anneke
I think you may want to look into SUMIFS. It will allow you to sum a specific range based on criteria that you establish and cross sheet references can be used.
It will probably end up looking something like this...
=SUMIFS({Column on other sheet to sum}, {Project column from other sheet}, [Project Number]12)
Okay, I´ll try it.
Thanks.
Hi there, I've created a sheet to where my team is tracking information received. In one column, we are logging the date and time information came in (ie: November 21, 2025 8:30 AM). I would like to add a checkbox column, with a formula specifying that the box be checked if the logged time is AFTER 8:30 AM, and left…
I have a column named Territory, where I am trying to write a formula to populate it when names are chosen from an adjacent drop-down list column called Employee Attendee. If more than one name is selected from the Employee column, I would like their respective territories to populate in the Territory field, separated by a…
I have a list of properties that I'm keeping track of. I have each building divided into suites (children) and each suite has a cell with its square footage. The total square footage rolls up to the building name. I also have a drop down column that shows if the suite is occupied or vacant. I need a to calculate the…
