SUMIF HELP NEEDED

[insomned]

Hello, 

I know I asked a similar question earlier, but still really don't get the logic. So I have a dataset as posted below, just of course with many more lines and more complicated. I need to sum, in this case - SA Recharge with Markup of SA and TA Recharge with Markup of TA. 

The way I see I could write a formula that IF Word 0 = Word 2, then SUM these rows (there can be more than two). Could anyone help me - where and how should I implement this formula, would this be the Multi-Row formula tool?

Thanks!

[binu_acs]

@insomned One way you can archive this by using the Find and Replace tool. 

[insomned]

Thanks for the suggestion, but I am afraid this wouldn't really work - I have a lot of categories, and as I can see here you're inputting a separate dataset just with these, I would then somehow need to also find a way how to extract these categories - and there are a lot of them.

[binu_acs]

@insomned Do you think the last and the first word will be always same ? in that case you can use the below approach

[Hamder83]

Maybe like this?