Forum Discussion
SUMIF
I am using two SUMIF formulae to add separately the positive and negative numbers in several rows of data. When I add a blank column to the start of those rows, the results of those formulae change....
Thanks for getting back to me. Happy to attach the worksheet but can't see how to do so on here and (ignorantly) unfamiliar with the other options.
I omitted to mention that I was inserting the blank column and the sorting alphabetically by a macro. I've just re-recorded the macro and the problem seems to have gone. Thank you anyway for your response.
Happy to hear it's been solved. Thanks for the feedback.
