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.
Thanks. I'll work on that.