View Single Post
  #1   Report Post  
Hirsch
 
Posts: n/a
Default sumif issues over multiple colums

=SUMIF(B:B,B92,AE:AE)+SUMIF(B:B,B92,AI:AI)+sumif(b :b,b92,AK:AK)


Any suggestions on how to condense this formula?

Is there such thing as

=SUMIF(B:B,B92,AE:AE&AI:AI:&AK:AK)
=SUMIF(B:B,B92,{AE:AE,AI:AI,AK:AK})