I have a list of customers that have a number attached to them. Several customers I want to exclude from all the information I am gather and so I have given the a number like 103.4, so that they fall in line in the right place but I don't want to count their data. How do I add the sum of a column of information except where the row whose cell in column D is not whole?
My formula currently looks like this.
=SUM(Y13:Y123)-(Y84+Y85+Y86+Y102)
It is simple but as I organize and rotate the data with new customers I am constantly going in and changing the subtraction because they are moving around.
Thank you,
Cya