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
|