I want to be able to total the value of individual sales in a row by product.
For instance in my row I have the sales product "fish" and a sales value at
the end of the row. Now in my sales sheet I may sell "fish" again to another
customer, which will be in another row. What I want it to do is add all my
fish sales values and pop it in a total value for that particular product. I
have other products all chosen from a pick list of around 7 and again I want
to calculate their total sales.
I think I've explained what I need? Can anyone Help