sumif problem

[Rick]

I am trying to add up multiple columns but from what I have read so far Sumif
won't do it.

=SUMIF($IE$3:$IE$62,B6,$IN$3:$IV$62) only returns the first value in column
IN.

How do I ADD all columns from IN to IV.

Thanks in advance

 

[Tyro]

That is because SUMIF makes the sum range agree in shape with the range that
you're comparing B6 to - $IE$3:$IE$62 - 1 column, so it sums only the first
column of your sum range. Use SUMPRODUCT instead:

=SUMPRODUCT((B6=$IE$3:$IE$62)*($IN$3:$IV$62))

Tyro

 

[T. Valko]

Try this:

Assuming the range IN3:IV62 contains only numeric values.

=SUMPRODUCT((IE3:IE62=B6)*IN3:IV62)