One more SUMIF array; thanks Aladin for earlier help
Posted by Jim on February 14, 2002 10:40 AM
Believe me, I've tried but for the life of me can't figure out how to make this work as an array or simplified formula.
=SUMIF(B5:AF5,"D",B6:AF6)+SUMIF(B7:AF7,"D",B8:AF8)+SUMIF(B9:AF9,"D",B10:AF10)+SUMIF(B11:AF11,"D",B12:AF12) and on, and on...
Thanks Aladin for help on similar COUNTIF as SUMPRODUCT, very ingenious!