Forum Discussion
Calculated Field in Pivot
Hello, I am new to Pivot Tables so please bear with me. I am trying to determine monthly costs for each job, represented by a WO#. My timesheet data is downloaded from Replicon but it does not conta...
sheridan60 While Vlookup will pull a value from a single cell (the first match in the lookup table - a single workorder entry), using sumif will pull values from several cells. Using sumif should allow you to pull the total by workorder rather than workorder entry.
Can I use sumif/sumifs if I have 3000 different identifiers, without entering detail for each one?
sheridan60 As long as you have the common keys in both tables, yes. For example, this formula uses both username and Workorder Number. It's just one formula which, if entered in a table object, will spill to all rows in that table.
=SUMIFS(Table3[Hours],Table3[Workorder],[@Workorder],Table3[Username],[@Username])