SUMIF HELP NEEDED
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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!
- Labels:
- Developer
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@insomned Do you think the last and the first word will be always same ? in that case you can use the below approach
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator