I want to count number of sales in this month till present & also need to count for only today's sales upto current time.

[sapxl]

Hello Friends, I'm trying to count the number of sales for the current day and current time… Also I want to count number of sales in this current month still the current month is going on currently (i.e, upto present day& time).. if any sales increase in next moment, then counting need to be increased.. using countif function, but unable to do so, can you help me on this. with my formula: SUM(COUNTIFS(D4:D17,">=1-May-20",D4:D17,"<=31-may-20")) It is giving only current month..and when i'm trying to use the below formula for present time updated, it is not giving the expected solution.. =SUM(COUNTIFS(D4:D17,">=1-May-20",D4:D17,"=today()")) Appreciate your help in this regard.

 

[Butterfly Asif]

Try it...
For all days of the month:
Count(D:D)
For Today:
IFERROR(IF(D2=TODAY(),COUNT(D:D),""),"")

 

[Butterfly Asif]

Try it...
For all days of the month:
Count(D:D)
For Today:
IFERROR(IF(D2=TODAY(),COUNT(D:D),""),"")

For Each Month:
COUNTIFS(D:D,">="&EOMONTH(D2,-1)+1,D:D,"<="&EOMONTH(D2,0))

 

[Fluff]

To count for this month use
=COUNTIFS(D4:D17,">="&EOMONTH(TODAY(),-1)+1,D4:D17,"<="&EOMONTH(TODAY(),0))

 

[sapxl]

Thanks a lot, Fluff.. the count for month is working great... But for the particular current day number of counts for sales or members.. is not working... i tried with the below functions:

COUNTIF(D4:D17,MID(D1,SEARCH("-",D4:D17)+1,3))

@ Butterfly asif, it is a nice try... Thanks

Is there any way to get the current day number of counts for sales or members registered, etc..

Thanks again for your help.

 

[Fluff]

I'm afraid I don't understand what you are asking for.

 

[Butterfly Asif]

Thanks a lot, Fluff.. the count for month is working great... But for the particular current day number of counts for sales or members.. is not working... i tried with the below functions:

COUNTIF(D4:D17,MID(D1,SEARCH("-",D4:D17)+1,3))

@ Butterfly asif, it is a nice try... Thanks

Is there any way to get the current day number of counts for sales or members registered, etc..

Thanks again for your help.

Try it...
For Current Period / Day:
IFERROR(IF(D2=MAX(D:D),COUNT(D:D),""),"")

 

[Butterfly Asif]

Try it...
For Current Period / Day:
IFERROR(IF(D2=MAX(D:D),COUNT(D:D),""),"")

OR
IFERROR(IF(D2=TODAY(),COUNT(D:D),""),"")

 

[sapxl]

Hi Fluff, Thanks a ton..... I'm sorry for the confusion... actually i'm seeing the count of sales for month wise and also for current day. Your given solution for month wise count is working fine.

I also want to have count for only the current day in particular, not for current month... is there any way to get the particular day count of today which is current...

Appreciate your help.

Please find the range for this query:

COUNTING ONLY TODAYS NUMBER OF SALES and THIS MONTH NUMBER OF SALES.xlsx
	A	B	C	D	E	F	G	H	I
3							11-Jul-20
4				22-Jun-20 7:22 PM
5				28-Jun-20 7:13 AM
6				29-Jun-20 7:13 AM
7				30-Jun-20 7:13 AM
8				10-Jul-20 7:22 PM
9				11-Jul-20 7:22 PM
10				12-Jul-20 7:22 PM
11				13-Jul-20 7:22 PM
12				14-Jul-20 7:22 PM
13				15-Jul-20 7:22 PM
14				11-Jul-20 7:22 PM
15				11-Jul-20 7:22 PM			44023.8070717593
16				11-Jul-20 7:22 PM
17				11-Jul-20 7:22 PM		0	COUNTIF(D4:D17,"=F17=G3"))
18
19
20
21			Hello friends, I want to count only today's date (i.e, 11-Jul-20) transactions or sales. The number of counts of sales transactions for today's only… is there any way to find this.. Your help is highly appreciated… COUNTIF(D4:D17,"=F17=G3") COUNTIFS(D4:D17,"=F17=G3",D4:D17,"<="&TODAY())
22
23
24
Sheet2

Cell Formulas
Range	Formula
G3	G3	=TODAY()
G15	G15	=RIGHT(D4:D17,16)
F17	F17	=COUNTIFS(D4:D17,"=F17=G3",D4:D17,"<="&TODAY())

 

[Fluff]

Ok, how about
=COUNTIFS(D4:D17,">="&G3,D4:D17,"<"&G3+1)

 

[sapxl]

Fluff, you are amazing man.... your solution worked again... Thank a lot.. no words to tell... except God Bless you....

Thanks again for your help...