View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Joe M. Joe M. is offline
external usenet poster
 
Posts: 97
Default SUMIF with multiple columns in sum range

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