MrManBoy
New Member
- Joined
- May 28, 2014
- Messages
- 37
- Office Version
- 365
- Platform
- Windows
- Mobile
- Web
Hi All,
I have a table similar to the one below:
[TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD]Product 1[/TD]
[TD]Product 2[/TD]
[TD]Product 3[/TD]
[TD]Product 4[/TD]
[TD]Product 5[/TD]
[TD]Total Cost[/TD]
[/TR]
[TR]
[TD]Shoes[/TD]
[TD]Chair[/TD]
[TD]Hat[/TD]
[TD]Belt[/TD]
[TD][/TD]
[TD]$100.00[/TD]
[/TR]
</tbody>[/TABLE]
What I am trying to achieve is getting the SUM total of any products selected under any of the product headings, where the pricing info is listed in another table. I can do this fine but I have found the formula ends up being a short story and I came to see if there was a more, slim down version.
Any help would be great thanks in advance
I have a table similar to the one below:
[TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD]Product 1[/TD]
[TD]Product 2[/TD]
[TD]Product 3[/TD]
[TD]Product 4[/TD]
[TD]Product 5[/TD]
[TD]Total Cost[/TD]
[/TR]
[TR]
[TD]Shoes[/TD]
[TD]Chair[/TD]
[TD]Hat[/TD]
[TD]Belt[/TD]
[TD][/TD]
[TD]$100.00[/TD]
[/TR]
</tbody>[/TABLE]
What I am trying to achieve is getting the SUM total of any products selected under any of the product headings, where the pricing info is listed in another table. I can do this fine but I have found the formula ends up being a short story and I came to see if there was a more, slim down version.
Any help would be great thanks in advance
