# =SUMIF Formula

Highlighted
Occasional Contributor

# =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 = 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

4 Replies
Highlighted

# Re: =SUMIF Formula

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.

Highlighted

# Re: =SUMIF Formula

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
Highlighted

# Re: =SUMIF Formula

Use SUMIF twice. SUMIF(once set of condition) + SUMIF(second set of condition).

This will give result in a single cell.

Highlighted

# Re: =SUMIF Formula

It could be

``=SUMPRODUCT(--(IF({1,0},D5:D44,I5:I44)="B.M.05")*IF({1,0},C5:C44,H5:H44))``