N
nander
I'm trying to calulate the daily sales to date in the attache
spreadsheet cell E39. With this formul
=C33/(COUNTIF(B4:B31,"<>")-COUNTIF(A4:A31,"")) This formulae return
the value 2703.52. However if you divide 64884.57 by 6 the value i
10,814.095. How should the formula be changed?
A B C
JUNE DHN GS$
DATE DAILY MTD
6/1/2006 18,635.51 18,635.51
6/2/2006 7,248.36 25,883.87
6/5/2006 9,064.83 34,948.70
6/6/2006 10,954.83 45,903.53
6/7/2006 10,495.26 56,398.79
56,398.79 56,398.79
6/8/2006 8,485.78 64,884.57
6/9/2006 0.00 64,884.5
+-------------------------------------------------------------------
|Filename: excel forum.zip
|Download: http://www.excelforum.com/attachment.php?postid=4868
+-------------------------------------------------------------------
spreadsheet cell E39. With this formul
=C33/(COUNTIF(B4:B31,"<>")-COUNTIF(A4:A31,"")) This formulae return
the value 2703.52. However if you divide 64884.57 by 6 the value i
10,814.095. How should the formula be changed?
A B C
JUNE DHN GS$
DATE DAILY MTD
6/1/2006 18,635.51 18,635.51
6/2/2006 7,248.36 25,883.87
6/5/2006 9,064.83 34,948.70
6/6/2006 10,954.83 45,903.53
6/7/2006 10,495.26 56,398.79
56,398.79 56,398.79
6/8/2006 8,485.78 64,884.57
6/9/2006 0.00 64,884.5
+-------------------------------------------------------------------
|Filename: excel forum.zip
|Download: http://www.excelforum.com/attachment.php?postid=4868
+-------------------------------------------------------------------