Count total by specific criteria formula pls

[gilquenanoviii]

Hi everyone, hope someone could help me which formula to use to get/count the total receipt # of each store. thank you in advance

342.xlsx
	A	B	C	D	E	F	G	H
1	Store	Receipt number	Sum of Quantity Sold	Sum of Sales
2	402	040201020124043943	-3	-270			STORE	TOTAL RECEIPT COUNT
3		040201020324044003	-3	-248			402
4		040201020324044028	-3	-360			404
5		040201020424044064	-3	-174			405
6		040201020524044141	-3	-110			412
7		040201020724044197	-3	-134			416
8		040201020724044205	-3	-114
9		040201021024044316	-3	-154
10		040201021024044335	-5	-284
11		040201021124044357	-3	-184
12		040202020224058495	-3	-134
13		040202020424058624	-3	-208
14		040202020824058743	-5	-246
15		040202020824058750	-3	-144
16		040202020824058755	-4	-163
17		040202020924058796	-3	-258
18		040202021124058907	-3	-190
19	404	040402021124050066	-3	-284
20		040404020324031693	-6	-431
21		040404020624032033	-7	-476
22		040404020924032251	-5	-428
23		040404021024032356	-5	-347
24		040404021024032380	-3	-150
25		040404021024032450	-3	-254
26		040404021124032483	-3	-98
27		040404021124032548	-3	-154
28		040404021124032587	-3	-144
29		040404021224032629	-3	-170
30		040404021224032630	-6	-384
31		040404021224032631	-3	-144
32	405	040501020224092927	-3	-134
33		040501020624093215	-8	-210
34		040501021124093730	-3	-114
35		040501021224093772	-3	-94
36		040502020224121764	-3	-130
37		040502020524122033	-3	-170
38		040502020924122307	-6	-417
39		040502021024122379	-3	-144
40		040502021224122568	-3	-84
41		040504020924022623	-7	-325
42		040504020924022673	-4	-157
43		040504021124022885	-3	-118
44		040504021124022964	-6	-293
45		040505020824070375	-3	-174
46		040505021024070433	-9	-452
47		040506020924096663	-4	-219
48		040508020224045527	-18	-890
49		040509020824113266	-4	-253
50		040509021024113542	-3	-214
51		040509021024113563	-3	-180
52		040509021224113677	-6	-451
53		040510020824083414	-7	-245
54		040510020924083472	-6	-363
55		040510020924083490	-6	-196
56		040512020224032828	-3	-168
57	412	041201020324064042	-3	-134
58		041201020524064337	-14	-1217
59		041204020124113831	-4	-163
60		041204020624114135	-3	-64
61		041204021224114471	-3	-173
Sheet11

 

[Joe4]

We cannot tell if column B is entered as Text or numbers with a special format.
Can you tell me what this formula returns?

=LEFT(B2,3)

 

[gilquenanoviii]

342.xlsx
	A	B	C	D	E	F	G	H
1	Store	Receipt number	Sum of Quantity Sold	Sum of Sales
2	402	40201020124043900	-3	-270			STORE	TOTAL RECEIPT COUNT
3		40201020324044000	-3	-248			402
4		40201020324044000	-3	-360			404
5		40201020424044000	-3	-174			405
6		40201020524044100	-3	-110			412
7		40201020724044100	-3	-134			416
8		40201020724044200	-3	-114
9		40201021024044300	-3	-154
10		40201021024044300	-5	-284
11		40201021124044300	-3	-184
12		40202020224058400	-3	-134
13		40202020424058600	-3	-208
14		40202020824058700	-5	-246
15		40202020824058700	-3	-144
16		40202020824058700	-4	-163
17		40202020924058700	-3	-258
18		40202021124058900	-3	-190
19	404	40402021124050000	-3	-284
20		40404020324031600	-6	-431
21		40404020624032000	-7	-476
22		40404020924032200	-5	-428
23		40404021024032300	-5	-347
24		40404021024032300	-3	-150
25		40404021024032400	-3	-254
26		40404021124032400	-3	-98
27		40404021124032500	-3	-154
28		40404021124032500	-3	-144
29		40404021224032600	-3	-170
30		40404021224032600	-6	-384
31		40404021224032600	-3	-144
32	405	40501020224092900	-3	-134
33		40501020624093200	-8	-210
34		40501021124093700	-3	-114
35		40501021224093700	-3	-94
36		40502020224121700	-3	-130
37		40502020524122000	-3	-170
38		40502020924122300	-6	-417
39		40502021024122300	-3	-144
40		40502021224122500	-3	-84
41		40504020924022600	-7	-325
42		40504020924022600	-4	-157
43		40504021124022800	-3	-118
44		40504021124022900	-6	-293
45		40505020824070300	-3	-174
46		40505021024070400	-9	-452
47		40506020924096600	-4	-219
48		40508020224045500	-18	-890
49		40509020824113200	-4	-253
50		40509021024113500	-3	-214
51		40509021024113500	-3	-180
52		40509021224113600	-6	-451
53		40510020824083400	-7	-245
54		40510020924083400	-6	-363
55		40510020924083400	-6	-196
56		40512020224032800	-3	-168
57	412	41201020324064000	-3	-134
58		41201020524064300	-14	-1217
59		41204020124113800	-4	-163
60		41204020624114100	-3	-64
61		41204021224114400	-3	-173
Sheet11

 

[gilquenanoviii]

We cannot tell if column B is entered as Text or numbers with a special format.
Can you tell me what this formula returns?

=LEFT(B2,3)

And I cannot tell if you are just looking for the total count of rows, or the total from column C?
Can you clarify that?

i resend it with number format sir

 

[Joe4]

You didn't answer my question - it looks like you just posted your data again.
Can you please tell me what that formula I posted returns if you enter it into any blank cell on your sheet?

That will not answer your question, it just tells me what kind of data we are working with so I know how to construct the formula that will answer your question.
Please just do that, and nothing else!

 

[gilquenanoviii]

You didn't answer my question - it looks like you just posted your data again.
Can you please tell me what that formula I posted returns if you enter it into any blank cell on your sheet?

That will not answer your question, it just tells me what kind of data we are working with so I know how to construct the formula that will answer your question.
Please just do that, and nothing else!

i put the formula you gave to a blank cell on my sheet and it gave me "402" sir.

 

[Joe4]

OK thank you.

Place this formula in cell H3 and copy down to H7:

=SUMPRODUCT(--(LEFT(B$2:B$61,3)=LEFT(G3,3)))

Note: If your data really goes past row 61, replace the "61" in the formula with the real last row number in your data set.