Can SUMPRODUCT be made to ignore text
SUMPRODUCT works in this way without any additional measure (I tested it in
Excel 2003)!
Regards,
Stefi
€˛Thanks€¯ ezt Ć*rta:
Hi
My Sum range occasionally has text included in it, is there a a way to make
sum product ignore the test when evaluating?
|