SUMIF(product!B345:product!B500,"orange",product!C 345:product!C500)/30
COLUMN C has numbers to sum.
COLUMN B has product names.
WORKSHEET NAME IS "product" and has all dates in
COLUMN A = dates from January to December 2008
I' like to adjust the above formula to use the whole range of the worksheet:
let's say 1 to 3000 using COLUMN A ( with dates ) accordinly to the month.

Results will be : suming in COLUMN C, if "orange" is in COLUMN B and if
COLUMN A has a date in January.
By the way, COLUMN A could repeat dates several times.
Too hard for me to figure it out. Thanks.