Does anyone have any suggestions on how to use sumproduct function?
I would like to determine the min and max numbers under column B, if and
only if cell A2 = 1-Aug-2009 and cell C2 = "C".
Does anyone have any suggestions on how to do it in excel?
Thanks in advance for any suggestions
Eric