How do I use DCOUNT function

S

SuhasKurse

DateMonthDayTemperatureRainfallFlyersPriceSales Revenue
1/1/2017JanuarySunday272.00150.310 $ 3.00
1/2/2017JanuaryMonday28.91.33150.313 $ 3.90
1/3/2017JanuaryTuesday34.51.33270.315 $ 4.50
1/4/2017JanuaryWednesday44.11.05280.317 $ 5.10
1/5/2017JanuaryThursday42.41.00330.318 $ 5.40
1/6/2017JanuaryFriday25.31.54230.311 $ 3.30
1/7/2017JanuarySaturday32.91.54190.313 $ 3.90
1/8/2017JanuarySunday37.51.18280.315 $ 4.50
1/9/2017JanuaryMonday38.11.18200.317 $ 5.10
How can I use DCount function to find number unique days. I am expection answer 7

Continue reading...
 
Back
Top Bottom