There is nothing different David. I'm needing seperate formula's for each

"David Biddulph" wrote:

If you want the average of the column C values that meet your criteria,
change your
=SUMPRODUCT((TEXT(A6:A100,"yyyymm")="200907")*(TE XT(A6:A100,"yyyymm")<="201006")*(B6:B100="d")*C6:C 100)to =SUMPRODUCT((TEXT(A6:A100,"yyyymm")="200907")*(TE XT(A6:A100,"yyyymm")<="201006")*(B6:B100="d")*C6:C 100)/SUMPRODUCT((TEXT(A6:A100,"yyyymm")="200907")*(TEX T(A6:A100,"yyyymm")<="201006")*(B6:B100="d"))--David Biddulph"mePenny" wrote in ...I have the following formula's to seperate out fuel (u=unleaded, d=diesel) for Fiscal (7/1/09 - 6/30/09) and Calendar year. I'm looking for anaverage of gallons of fuel formula for the Fiscal and Calendar year. Can anyonehelp? mePenny Calendar =SUMPRODUCT((YEAR(A6:A100)=2009)*(B6:B100="u")*C6: C100) =SUMPRODUCT((YEAR(A6:A101)=2009)*(B6:B101="d")*C6: C101)
Fiscal=SUMPRODUCT(((YEAR(A6:A100)=2009)*(MONTH(A6 :A100)=7)+(YEAR(A6:A100)=2010)*(MONTH(A6:A100)<=6 ))*(B6:B100="u")*C6:C100)=SUMPRODUCT((TEXT(A6:A1 00,"yyyymm")="200907")*(TEXT(A6:A100,"yyyymm")<=" 201006")*(B6:B100="d")*C6:C100)

.