I'm lookign at doing a SUMPRODUCT forumula which references items, for example. =SUMPRODUCT((P1:P2000=$A$1)...) where $A$1 is a VLOOKUP'd formula to show FR1, FR2, FR3 etc.
i'd like to get an option to show "Total" which shows all from FR1 to FR20, for example, is it possible to set A1 to be a value or something which will allow that?
Bookmarks