Hi there, I'm new here (so please be gentle )
So I'm trying to create a calculator for a game I've been playing (very productive, I know) and I've reached the part where I have to calculate different ratings (damage, critical, etc) for each skill. Now each skill has various tags (combinations of Physical/Energy, Melee/Ranged, Area, etc) so I need to get the rating value for those tags and add them up.
I've tried using things like DSUM but if a Tag column is empty, it somehow ended up adding all values instead of just the specific ones. Anyway, explaining it here would probably be long n unnecessary so here's my sample workbook
Sample.xlsx
Note: I managed to get what I wanted by using SUM and VLOOKUP but the resulting formula gets lengthy, so I'm wondering if there's a better, simpler way to do it.
Thanks in advance for your help
Bookmarks