Well, I'm glad you got to the solution yourself. Thanks for the rep (though I didn't really do anything).
If you had the categories "Beer", "Wine", "Liquor" etc. in a column somewhere, then you could just reference each cell instead of including them explicitly in each formula, and then the formula could be copied down without needing to change it. This wouldn't work for the last formula, though.
Hope this helps.
Pete
The reason I did it this way, is because the I'm General Manager making sheets that will be used by my supervisors, all of whom are very limited in their Excel acumen. I've made one "Category" column in which each cell has a drop-down data-validation list of options for ease of use and congruity of records.
Long story short, I'm making the process of spreadsheet-building more difficult and tedious for myself in an attempt to make the final sheets as user-friendly as possible for my team.
Last edited by Natejss; 02-10-2019 at 04:46 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks