•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Summing range between two lookup values in another column
Hello! I have a list of two-letter alphabetical codes. Each has a corresponding item count. Per the image below, I would like to input two lookup values (shown in B3, C3) and return a count of the number of items inclusive of, and between, those two values in column G.
For example, if I input AA and AD, I want it to return the value "128" (0+58+18+52). I tried using SUMIFS, but that seems to only pluck out two values rather than the entire range between those two (e.g., lookups of AA and AD would return "52"). I feel like this is beyond my current skillset. Any help?
[link] [comments]
Want to read more?
Check out the full article on the original site