I have a table like such below and I am using the following formula =SUM(SUM(D17)-SUMIFS(E5:E22,A5:A22,A17,B5:B22,B17-N4)) to return the result. For this example I should return a -0.05 (0-0.05)
N4 = 25
I hope I can explain this clearly
If the value in the cell = Column D ie 0 or...