sumif problem
 

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

sumif problem
 

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

"Rick" wrote in message
...
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

sumif problem
 

Try this:

Assuming the range IN3:IV62 contains only numeric values.

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

--
Biff
Microsoft Excel MVP


"Rick" wrote in message
...
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