Hi, I tested it and it's working , are you using excel 2007 ? "mePenny" wrote: This tells me #NAME? for both "Eduardo" wrote: Hi, =AVERAGEIFS(C6:
C100,A6:A100,"2009",B6:B100,"u") =AVERAGEIFS(C6:C100,A6:A100,"2009",B6:B100,"d") "mePenny" wrote: I have the following formula's to seperate out fuel (u=unleaded, d=diesel) for Fiscal (7/1/09 - 6/...