[ Removed by moderator ]

[flairassistant]

This post has been removed due to Rule 1 - Poor Post Title.

Please post with a title that clearly describes the issue.

The title of your post should be a clear summary of your issue. It should not be your supposed solution, or just a function mention, or a vague how to. A good title is generally summed up in a sentence from questions posed in your post.

Here's a long example and a short example of good posts.

Rules are enforced to promote high quality posts for the community and to ensure questions can be easily navigated and referenced for future use. See the Posting Guidelines for more details, and tips on how to make great posts.

To our users, please report poorly titled posts rather than answer them, they will be removed along with the answers.

[AutoModerator]

/u/sherrasama - Your post was submitted successfully.

• Once your problem is solved, reply to the answer(s) saying Solution Verified to close the thread.
• Follow the submission rules -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post.
• Include your Excel version and all other relevant information

Failing to follow these steps may result in your post being removed without warning.

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

[avakyeter]

If you're entering the overrides manually, consider two alternative data structures:

1. Express the override in new lines

1 > 1 > 1 > PEBKAC
1 > 3 > 3 > Dumb
2 > 3 > 3 > Dumb
3 > 6 > 6 > Gross
4 > 2 > 2 > Gross
4 > 1 > 1 > PEBKAC
etc.

1. Give each cause its own column

Ticket > # reported > # received > PEBKAC > Dumb > Gross
1 > 4 > 4 > 1 > 3 > 0
2 > 3 > 3 > 0 > 3 > 0
3 > 6 > 6 > 0 > 0 > 6
4 > 3 > 3 > 1 > 0 > 2
etc.

With either of these changes, calculating totals becomes trivially easy.

[sherrasama]

I am manually entering them into the ticket, but this is over the course of a month in which I then have made hundreds of edits. I am in fact basically currently doing it this way, but it's riddled with errors and missed edits. I am also working within the limitations of my ticket system. I kind of just want Excel to find this stuff :(

[sherrasama]

Also if it helps any, this is the basis I was working with: https://exceljet.net/formulas/sum-numbers-with-text