I have one column that can assume one of two preset values (incoming/outgoing). There's also a column to specify the exact amount of kilos that is incoming/outgoing.
What I want to do is to have one cell containing a formula that makes a summation of (all incoming - all outgoing). How should this formula look, there's about ten rows of information.
Thanks in advance
/Magnus
What I want to do is to have one cell containing a formula that makes a summation of (all incoming - all outgoing). How should this formula look, there's about ten rows of information.
Thanks in advance
/Magnus