May 28 2020 09:04 PM
Hi All,
Using Sum if as a tally to work out how much weld a welder has done, so i have multiple tables of weld id's then beside them the length they did.
Welder ID = Column D
Length = Column C
Below is the formula im using;
=SUMIF(D5:D44,"B.M.05",C5:C44)
However instead of just D5:D44 i want to be able to do this to I5:I44 aswell at the same time aswell as instead of just C5:C45 i want H5:45 aswell.
What is the best way to go around this?
Cheers, Josh
May 29 2020 01:11 AM
Just the change reference column from D to I and C to H. Make sure the number of rows are same in both data range i.e. if range and sum range.
May 29 2020 01:17 AM
May 29 2020 01:19 AM
Use SUMIF twice. SUMIF(once set of condition) + SUMIF(second set of condition).
This will give result in a single cell.
May 29 2020 01:42 AM