I have a sumifs formula that is working correctly, but is extremely long and I am hoping to get it shortened. The formula I have set up is as follows:
Now this isn't the full formula, but this shows how it looks. The "Test!$B$1" part of the sumifs formula goes from B$1$ all the way to B$30$, so the formula is very long. In order to shorten the formula, I have been trying to replace the Second Criteria ("Test!$B$1") in the Second Criteria Range ("Data!$B$2:$B$39654") of the sumifs formula with some sort of constant value, but can't seem to figure it out. Is there anyway to shorten this formula? Or is there a different variation I could use?
I appreciate any and all help.
Thank-you
Bookmarks