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....
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.