=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})
=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})
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks