Simple Macro - Sum of values that are related to a sprecific word chosen by you.

[Adam Brave]

Hi,

I want to do a simple macro but I'm having some troubles and I think you may help me.

I have a table with just two columns (the first column has numbers and the second words) and some rows. So I want to create a macro that consists on a loop with a condiction inside. This macro would sum all the values of the first column that meet a specific word on the second column like the example bellow where the result would be 2+5= "7". The specific word that I want to test should be specified and written by me at the beginning of the macro in a popup box that in the example bellow would be "food".

Can anyone help me?

2	food
1	football
5	food
4	cinema

Best regards,