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" <Hirsch@discussions.microsoft.com> wrote in message
news:94CC8248-40D4-4D64-A868-C005CCB41DF6@microsoft.com...
> =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" <Hirsch@discussions.microsoft.com> wrote in message
news:94CC8248-40D4-4D64-A868-C005CCB41DF6@microsoft.com...
> =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" <Hirsch@discussions.microsoft.com> wrote in message
news:94CC8248-40D4-4D64-A868-C005CCB41DF6@microsoft.com...
> =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})
>