How to make sum by reading the two Columns

[Bpt_143]

Hi,

I new to this site and this is my first post, generally i poor in excel so please guide me on this
Thanks in Advance.

Red Highlighted valve are outcome of the formula
This formula need to read two column (WS and R/F) at the right side, Both Columns are manually entered, outcome is total of feed valve, total of rapid valve and total of feed and rapid valve. for example i have given only one feed in real case there will be multiple of feeds and rapid.

Is it possible to make formula for this?

[TABLE="width: 384"]
<tbody>[TR]
[TD="class: xl65, width: 64"]FEATURE[/TD]
[TD="class: xl68, width: 64"] X[/TD]
[TD="class: xl68, width: 64"] Y[/TD]
[TD="class: xl68, width: 64"] Z[/TD]
[TD="class: xl68, width: 64"] WS[/TD]
[TD="class: xl65, width: 64"]R/F[/TD]
[/TR]
[TR]
[/TR]
[TR]
[TD="class: xl66"][/TD]
[TD="class: xl66, align: right"]28.5[/TD]
[TD="class: xl66, align: right"]-113[/TD]
[TD="class: xl66, align: right"]253.3[/TD]
[TD="class: xl65"]-[/TD]
[TD="class: xl67"] Rapid[/TD]
[/TR]
[TR]
[TD="class: xl66"][/TD]
[TD="class: xl66, align: right"]28.5[/TD]
[TD="class: xl66, align: right"]-113[/TD]
[TD="class: xl66, align: right"]250.3[/TD]
[TD="class: xl66, align: right"]3[/TD]
[TD="class: xl67"] Rapid[/TD]
[/TR]
[TR]
[TD="class: xl66"][/TD]
[TD="class: xl66, align: right"]9[/TD]
[TD="class: xl66, align: right"]-92.7[/TD]
[TD="class: xl66, align: right"]250.3[/TD]
[TD="class: xl66, align: right"]28.15[/TD]
[TD="class: xl67"] Feed[/TD]
[/TR]
[TR]
[TD="class: xl66"][/TD]
[TD="class: xl66, align: right"]9[/TD]
[TD="class: xl66, align: right"]-92.7[/TD]
[TD="class: xl66, align: right"]253.3[/TD]
[TD="class: xl66, align: right"]3[/TD]
[TD="class: xl67"] Rapid[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Rapid[/TD]
[TD="class: xl70"]6[/TD]
[TD="class: xl70"][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Feed[/TD]
[TD="class: xl70"]28.15[/TD]
[TD="class: xl70"][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Total[/TD]
[TD="class: xl70"]34.15[/TD]
[TD="class: xl70"][/TD]
[/TR]
</tbody>[/TABLE]
Thanks in Advance,
Best Regards,
Boopathy K

 

[Jonmo1]

Welcome to the board.

You can use SUMIF for that

Assuming that table you posted is at the very top left of a sheet, the word FEATURE is in A1.
In E6, put
=SUMIF($F$2:$F$5,$D6,$E$2:$E$5)

 

[Bpt_143]

Hello,

Thanks for your immediate response,
This is working thank once again.

 

[Jonmo1]

You're welcome.