Sorry -

I guess I didn't really answer your first questions. You can use SUMIFS or SUMPRODUCT. SUMPRODUCT has a little more computational overhead, so for VERY large spreadsheets you might see some performance degradation. However, SUMPRODUCT can work on closed workbooks, so if you data is in a separate file that isn't open, SUMPRODUCT will still work and SUMIFS won't. It's really up to you. I prefer SUMPRODUCT just because that is the function I learned on and it makes sense to me. SUMIFS gives me fits sometimes because the search criteria often seems to be in a string format which I usually need 3 or 4 tries to get it right.