Formula modification help.

Jennie Jones

I need to modify a formula to pull values of two different cells "SAP PROJECT NUMBER" and "JOB NUMBER" from another "Time Tracking" sheet. I make it work with pulling just one lookup but not two. Below is my formula for one - where to I add the [JOB Number] so it pulls both in this formula?

=SUMIFS({Time Tracking Range 4}, {Time Tracking Range 5}, [SAP Project Number]1383)

Kelly Moore

Hi Jennie

Just to verify your formula, the {Time Tracking Range 4} should be the column you're trying to sum, like $ or time, for example.

To help ensure that we're referring to the same range, I'll specifically call out the range by name.

=SUMIFS({Time Tracking -the column you're summing}, {Time Tracking SAP Number}, @cell = [SAP Project Number]@row, {Time Tracking Job Number}, @cell=[Job Number]@row)

Be sure to change the ranges in the formula to your real range names.

If this doesn't work, let me know and we can re-work it.