I have a workbook that in column O it has positive and negative figures. What im trying to do is to have 2 seperate subtotals in the column with O999 Showing the value of all the positive figures added together and then O1000 with all the negative figures added together.
Can that be done?
Can that be done?