=SUMIF Formula

[CBHJoshD]

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

[#2]

@CBHJoshD 

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.

[#3]

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

[#4]

@CBHJoshD 

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

This will give result in a single cell.

[#5]

@CBHJoshD 

It could be

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