I am trying to find a formula that will sum cells based on criteria. For example, if I select an input of 1, I need it to add cells A1 and B6,11,16, & 21. An input of 2 needs to sum cells A1, A5 and B11, 16, & 21. I was wondering if INDEX would work in this case. Thanks in advance!
Bookmarks