Hi there,
I was just wondering if there is some way of using the sumifs function to minus or subtract a range of data from a large data set? I have a large data set that picks up contract codes in column A and the cost against these in column B. I am looking to exclude certain contract codes and was looking to see if the sumifs function would work in this way? The lines of data run to 500 lines plus with multiple contract codes and costs.