SUMIF + IF/THEN Formula

[Rana Gray]

Hey Everyone,

I'm getting a little confused on writing this formula. This is what I have: =SUMIF(F9:F25,"*BMO*",K9:K25)+SUMIF(G9:G25,"*BMO*",K9:K25)

This is what I need to add: My range is currently set to K9:K25, however I want the sumif range to use the value in J9:J25 instead when there is a value and if not then use what is in the original range. I hope that makes sense - Based on reference image: if the "Limit" column has a value then add that to the SUM instead of the value in the "Balance" column otherwise just use the "Balance" column.

Thanks in advance!

** Edit to Add: I'm fine with using VBA if a formula isn't sufficient **

 

[ExceLoki]

this this:

=IFERROR(SUMIFS(J9:J25,G9:G25,"BMO"),0)+IFERROR(SUMIFS(K9:K25,G9:G25,"BMO",J9:J25,""),0)

 

[Rana Gray]

this this:

=IFERROR(SUMIFS(J9:J25,G9:G25,"BMO"),0)+IFERROR(SUMIFS(K9:K25,G9:G25,"BMO",J9:J25,""),0)

You are a Genius <3

 

[ExceLoki]

happy to help

 

[smozgur]

You are a Genius <3

The marked solution has been changed accordingly. In your future questions, please mark the post as the solution that actually answered your question, instead of your feedback message as it will help future readers. No further action is required for this thread.

 

[Rana Gray]

The marked solution has been changed accordingly. In your future questions, please mark the post as the solution that actually answered your question, instead of your feedback message as it will help future readers. No further action is required for this thread.

Duly noted!! I'll be more careful on future posts, thank you!!