nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Welcome!

Sum up rows within the VLOOKUP formula

Anneke Guilliard

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

Screenshot_time tracking table.png

Find more posts tagged with

Healthcare

Formulas

Project Management

Comments

Paul Newcome

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)

Anneke Guilliard

Okay, I´ll try it.

Thanks.

Sign in to join the conversation!

Quick Links

Trending discussions

Does the cell history come over when a row is moved from one sheet to another
I have written an automation that moves content from one sheet to another when certain criteria are met. I thought the cell history came across with the row but when I click on "View Cell History" after it is moved, I only get the history for the move and nothing prior. Is this working as designed?
Absentee Calendar/Log
Good morning, We have an absentee calendar for approximately 150 employees, including 30 supervisors. Supervisors absences must be notified to a specific group. Automation works well for single day absences, but when an absence spans multiple days, the supervisor is not consistently included in daily (Mon-Fri)…
How to Get Attachment to Work on Automation
Hello All! I have an automation that is set as Trigger: When a Date is Reached —> Run Once on Date at 5pm. Conditions: Where two separate checkboxes are checked. Alert someone—> Message, Link to sheet and specific fields (an attachment). The automation worked except the attachment. It wasn't included at all on the…