Thanks guys.
but for some reason is not working, however I'll figure this one out.

"Fred Smith" wrote:

Sumif cannot handle more than one condition.

If you have xl2007, you can use Sumifs. If not, use Sumproduct, as in:

=SUMPRODUCT(--(MONTH(Product!A345:A500)=1),--(Product!B345:B500="Orange"),Product!C345:C500)

Regards,
Fred

"computexcel" wrote in message
...
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.