•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
Tagged with
#Excel alternatives for data analysis
#rows.com
#natural language processing for spreadsheets
#generative AI for data analysis
#Excel compatibility
#Excel alternatives
#item count
#Excel
#lookup values
#two-letter codes
#count
#SUMIFS
#range
#value
#values
#inclusive
#column G
#return
#summation
#between