Thread
:
sumif issues over multiple colums
View Single Post
#
1
Hirsch
Posts: n/a
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})
Reply With Quote