I'm taking a long shot here but my question is
can sumproduct or sumif be used in VBA with a User filling in the blanks
with selections or text he/she has entered?