Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have an array that I need to sum multiple columns depending of the value in
Col D. The ws containing the array is called 'data'. I must sum cols F,J,N,R,V,Z in rows 7-25. On another ws my formula is: =SUMIF(Data!$D$7:$D$25,$A4,Data!$F$7:$F$25) Of course this only gives me the sum of Col F. Is there a way to put the sum range in one formula? I want to avoid stringing a bunch of SUMIFs together. Thanks, Joe M |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
SUMIF-with 2 conditions, need to add range in 2 columns | Excel Worksheet Functions | |||
Sumif Multiple Columns | Excel Worksheet Functions | |||
want sumif function's range to evaluate 2 columns | Excel Worksheet Functions | |||
SUMIF using two columns in both Range and Criteria | Excel Discussion (Misc queries) | |||
SUMIF using two columns in both Range and Criteria | Excel Worksheet Functions |