Hi,

Try this

=SUMPRODUCT((Product!A1:A40<"")*(MONTH(Product!A1 :A40)=1)*(Product!B1:B40="Orange")*(Product!C1:C40 ))

In practice I'd put the date as a cell reference and have the moth your
looking for in that.

Mike

"computexcel" wrote:

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.