|Please keep in mind that I cannot see your spreadsheet from where I am sitting, so it's hard for me offer a solution that will match your exact data. As I suggested in my earlier response, perhaps some example data would help.|
Checking for "any balances at all" across 4 columns is easy:
Basically what this does is start by evaluating COUNTIF(A1:D1,">0") which will count how many cells in A1:D1 contain a value greater than zero. As long as the result of the COUNTIF function is 1 or more, the IF function will see it as TRUE and return "Yes".
As far as your 3-column-month-to-month test, I am having trouble understanding what you are trying to do and when you want a Yes or a No. I need to know what columns you are comparing to what.
I really think some example data - both the input data and the desired output based on that data - would be helpful. Please click on the following line and read the instructions on how to post example data in this forum.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.