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.

 

[Fluff]

You're welcome & thanks for the feedback.

 

[sapxl]

Hi Fluff,

It would be kind if you could help me out for SUMING for only that day's sales amounts accumulated on that particular date. Appreciate your help.

Thanks in advance

COUNTING ONLY TODAYS NUMBER OF SALES and THIS MONTH NUMBER OF SALES.xlsm
	A	B	C	D	E	F	G	H	I
4			7/18/2020
5
6				DATE		AMOUNT
7
8				22-Jun-20 7:22 PM		700
9				28-Jun-20 7:13 AM		800
10				29-Jun-20 7:13 AM		6000
11				30-Jun-20 7:13 AM		200
12				10-Jul-20 7:22 PM		5300
13				11-Jul-20 7:22 PM		700
14				12-Jul-20 7:22 PM		900
15				13-Jul-20 7:22 PM		400
16				14-Jul-20 7:22 PM		800
17				15-Jul-20 9:54 PM		500
18				18-Jul-20 7:22 PM		300
19				18-Jul-20 6:33 PM		300
20				18-Jul-20 11:22 PM		100
21				18-Jul-20 9:23 PM		300
22				18-Jul-20 1:50 PM		5500
23				18-Jul-20 3:15 PM		500
24				18-Jul-20 7:22 PM		6000
25				18-Jul-20 7:30 PM		400
26
27
28
29							0	8
30
Sheet6

Cell Formulas
Range	Formula
C4	C4	=TODAY()
G29	G29	=COUNTIF(D4:D25,"TODAY()")
H29	H29	=SUM(COUNTIFS(D8:D25,">="&C4,D8:D25,"<"&C4+1))

 

[sapxl]

I'm also trying with this SUMIF formula (=SUMIF(D8:D25, C4,F8:F25) ) , but of no luck.. Appreciate your help in this regard. Thanks,

COUNTING ONLY TODAYS NUMBER OF SALES and THIS MONTH NUMBER OF SALES.xlsm
	B	C	D	E	F	G	H	I
4		18-Jul-20
5
6			DATE		AMOUNT
7
8			22-Jun-20 7:22 PM		700
9			28-Jun-20 7:13 AM		800
10			29-Jun-20 7:13 AM		6000
11			30-Jun-20 7:13 AM		200
12			10-Jul-20 7:22 PM		5300
13			11-Jul-20 7:22 PM		700
14			12-Jul-20 7:22 PM		900
15			13-Jul-20 7:22 PM		400
16			14-Jul-20 7:22 PM		800
17			15-Jul-20 9:54 PM		500
18			18-Jul-20 7:22 PM		300
19			18-Jul-20 6:33 PM		300
20			18-Jul-20 11:22 PM		100
21			18-Jul-20 9:23 PM		300
22			18-Jul-20 1:50 PM		5500
23			18-Jul-20 3:15 PM		500
24			18-Jul-20 7:22 PM		6000
25			18-Jul-20 7:30 PM		400
26
27
28
29						0	8
30
31							0
32
Sheet6

Cell Formulas
Range	Formula
C4	C4	=TODAY()
G29	G29	=COUNTIF(D4:D25,"TODAY()")
H29	H29	=SUM(COUNTIFS(D8:D25,">="&C4,D8:D25,"<"&C4+1))
H31	H31	=SUMIF(D8:D25, C4,F8:F25)

 

[Fluff]

How about

+Fluff New.xlsm
	A	B	C	D	E	F	G	H
1
2
3
4			18/07/2020
5
6				DATE		AMOUNT
7
8				22/06/2020 19:22		700
9				28/06/2020 07:13		800
10				29/06/2020 07:13		6000
11				30/06/2020 07:13		200
12				10/07/2020 19:22		5300
13				11/07/2020 19:22		700
14				12/07/2020 19:22		900
15				13/07/2020 19:22		400
16				14/07/2020 19:22		800
17				15/07/2020 21:54		500
18				18/07/2020 19:22		300
19				18/07/2020 18:33		300
20				18/07/2020 23:22		100
21				18/07/2020 21:23		300
22				18/07/2020 13:50		5500
23				18/07/2020 15:15		500
24				18/07/2020 19:22		6000
25				18/07/2020 19:30		400
26
27
28
29								8
30
31								13400
Main

Cell Formulas
Range	Formula
C4	C4	=TODAY()
H29	H29	=COUNTIFS(D8:D25,">="&C4,D8:D25,"<"&C4+1)
H31	H31	=SUMIFS(F8:F25,D8:D25,">="&C4,D8:D25,"<"&C4+1)

 

[sapxl]

you are Amazing bro.....it is a piece of cake for you... Brilliant...

Thanks once again..

 

[Fluff]

Glad to help & thanks for the feedback.