steven-g Posted August 31, 2015 Share Posted August 31, 2015 It would be easiest if you use column E for a sub-total (use the formula "=C3*D3" and copy it down the column) And then in Cell J3 use the formula "=sumif(B:B,I3,E:E)" and copy that down to the next few cells, that will give you the total for each item. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.