Thread: Sumif help
View Single Post
  #1   Report Post  
Hirsch
 
Posts: n/a
Default Sumif help


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

is there a way to condense this formula.

i.e. =sumif(b:b,b92,ae:ae&ai:ai&ak:ak)

Thanks in advance.