Monthwise calclulation

Hi

I used the month table you have at the side for the sum and the average per month.

In I4, copied down...
=SUMIFS($C$4:$C$93,$A$4:$A$93,">="&H4,$A$4:$A$93,"<"&H5)
In J4, copied down...
=IFERROR(AVERAGEIFS($C$4:$C$93,$A$4:$A$93,">="&H4,$A$4:$A$93,"<"&H5),"")

Note...make sure all the dates in H begin with the 1st of the month. you have some that start on the 12th etc

sorry total isnt coming 111 for jan12 month

Originally Posted by FDibbins

Note...make sure all the dates in H begin with the 1st of the month. you have some that start on the 12th etc

your date for Jan is not 1/1/2012, it is 1/11/2012 and 2/12/2012

yes its sales which can be on any day...
I mean to say sir on there may be some reason where on 1st day.. there would be no sale