I'm trying to calulate the daily sales to date in the attached
spreadsheet cell E39. With this formula
=C33/(COUNTIF(B4:B31,"<")-COUNTIF(A4:A31,"")) This formulae returns
the value 2703.52. However if you divide 64884.57 by 6 the value is
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.57


+-------------------------------------------------------------------+
|Filename: excel forum.zip |
|Download: http://www.excelforum.com/attachment.php?postid=4868 |
+-------------------------------------------------------------------+

--
nander
------------------------------------------------------------------------
nander's Profile: http://www.excelforum.com/member.php...fo&userid=6156
View this thread: http://www.excelforum.com/showthread...hreadid=550391