Re-word my questions

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 any cell under column A = 1-Aug-2009 and under column C = "C".
Does anyone have any suggestions on how to do it in excel?
Thanks in advance for any suggestions
Eric