Forum Discussion
=SUMIF Formula
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 = Colum...
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.
- I would like to do both the of the columns in the one formula, I need to get the result all in the one cell
Use SUMIF twice. SUMIF(once set of condition) + SUMIF(second set of condition).
This will give result in a single cell.
