|I'm still confused. |
You said: Column E needs to add the IN's from SUPPLIER and minus the OUT's to SR-. The IN's (DF,KB,KG) are internal warehouse transfers from the main W/H so not relevant.
When I look at your table, SUPPLIER is under the OUT heading and the SR- entries are under the IN heading. Isn't that the opposite of what you said in your text?
In any case, I can get the values you have in Column E with this formula but I'm not sure if it is what you are looking for.
You didn't use Row numbers in your example, so I am assuming your column headers are in Row 1. If I put that formula in E2 and drag it down, E2:E8 will Sum to £40.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.