im looking for a formula that returns two seperate values based on two different texts in other columns
e.g
[TABLE="width: 500"]
<tbody>[TR]
[TD]£10[/TD]
[TD]£15[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Product[/TD]
[TD]Cost[/TD]
[/TR]
[TR]
[TD]Windows[/TD]
[TD]10[/TD]
[/TR]
[TR]
[TD]Windows & Doors[/TD]
[TD]15[/TD]
[/TR]
[TR]
[TD]Windows[/TD]
[TD]10[/TD]
[/TR]
</tbody>[/TABLE]
I then need to be able to sum the total cost
Thanks
e.g
[TABLE="width: 500"]
<tbody>[TR]
[TD]£10[/TD]
[TD]£15[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Product[/TD]
[TD]Cost[/TD]
[/TR]
[TR]
[TD]Windows[/TD]
[TD]10[/TD]
[/TR]
[TR]
[TD]Windows & Doors[/TD]
[TD]15[/TD]
[/TR]
[TR]
[TD]Windows[/TD]
[TD]10[/TD]
[/TR]
</tbody>[/TABLE]
I then need to be able to sum the total cost
Thanks