SUMIF HELP NEEDED

Question

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!

Hamder83 · Answer

Maybe like this?

Sample.yxzp

binu_acs · Answer

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

sum3.yxmd

insomned · Answer

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.