Sum column W if column Q equals 390 & column L equal McL
S Sloth Aug 4, 2006 #2 =SUMPRODUCT(W1:W100,(Q1:Q100=390)*(L1:L100="McL")) I think this is what you need.
C Carolyn Aug 4, 2006 #3 Thanks! Sloth said: =SUMPRODUCT(W1:W100,(Q1:Q100=390)*(L1:L100="McL")) I think this is what you need. Click to expand...
Thanks! Sloth said: =SUMPRODUCT(W1:W100,(Q1:Q100=390)*(L1:L100="McL")) I think this is what you need. Click to expand...
