Hi Colin,


I think I got it. When using sumproduct for coutifs I can usd the * or --.


When using sumproduct as sumif I can use the -- but if I am using * I need to have at least two conditions and excluding the column name heading.



Let me know. Still learning the sumproduct functions.


Thanks,

Angie