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})

See answer to your first post.
--
Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit!
-------------------------------------------------------------------

"Hirsch" wrote in message
...
=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})