Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sumif Problem | Excel Worksheet Functions | |||
=SUMIF Problem | Excel Worksheet Functions | |||
SUMIF problem... | Excel Worksheet Functions | |||
SUMIF problem | Excel Worksheet Functions | |||
SUMIF problem | Excel Worksheet Functions |