sumif issues over multiple colums

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

=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})
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sumif help 1
Modifying sumif formulas. 4
Macro Covering Many Columns, why has to be UNION 1
SUMIF vs SUMPRODUCT 2
Total last 30 days 6
SUMIF cells in Column B are blank 9
=sumif function 1
Help with Sumif and INDIRECT 9

Back
Top