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....
Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?
- 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.
