Formula Adjusting
Both the formula you have are slightly different but both work for the data
layout you gave.
If they don't then suspect your data. Both require a correctly formatted
date in Column A.
Check for rogue spaces in column B
are the numbers in column C really numbers?
Mike
"computexcel" wrote:
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.
|