count number of voucher per day

[yky]

I have sales data which I need to count the number of voucher for each day. Is there a formula to do so?

Desired outcome: 4-5-0-3-2 for the five days.

DATE	VOUCHER NO.
1-Oct-16	091
1-Oct-16	092
1-Oct-16	093
1-Oct-16	094
1-Oct-16	094
2-Oct-16	095
2-Oct-16	095
2-Oct-16	096
2-Oct-16	096
2-Oct-16	097
2-Oct-16	097
2-Oct-16	098
2-Oct-16	099
3-Oct-16
4-Oct-16	100
4-Oct-16	001
4-Oct-16	002
4-Oct-16	002
5-Oct-16	003
5-Oct-16	003
5-Oct-16	003
5-Oct-16	003
5-Oct-16	004

<tbody>
</tbody>

 

[jarjarbingie]

I have sales data which I need to count the number of voucher for each day. Is there a formula to do so?

Desired outcome: 4-5-0-3-2 for the five days.

DATE	VOUCHER NO.
1-Oct-16	091
1-Oct-16	092
1-Oct-16	093
1-Oct-16	094
1-Oct-16	094
2-Oct-16	095
2-Oct-16	095
2-Oct-16	096
2-Oct-16	096
2-Oct-16	097
2-Oct-16	097
2-Oct-16	098
2-Oct-16	099
3-Oct-16
4-Oct-16	100
4-Oct-16	001
4-Oct-16	002
4-Oct-16	002
5-Oct-16	003
5-Oct-16	003
5-Oct-16	003
5-Oct-16	003
5-Oct-16	004

<tbody>
</tbody>

=IFERROR(SUM(IF($A$2:$A$24=$F2, 1/(COUNTIFS($A$2:$A$24, $F2, $B$2:$B$24, $B$2:$B$24)), 0)),0) press CTRL+SHIFT+ENTER

 

[MARZIOTULLIO]

	A​	B​	C​	D​	E​	F​	G​
1​	1-Oct-16​	91​			1-Oct-16​		4​
2​	1-Oct-16​	92​			2-Oct-16​		5​
3​	1-Oct-16​	93​			3-Oct-16​		0​
4​	1-Oct-16​	94​			4-Oct-16​		3​
5​	1-Oct-16​	94​			5-Oct-16​		2​
6​	2-Oct-16​	95​
7​	2-Oct-16​	95​
8​	2-Oct-16​	96​
9​	2-Oct-16​	96​
10​	2-Oct-16​	97​
11​	2-Oct-16​	97​
12​	2-Oct-16​	98​
13​	2-Oct-16​	99​
14​	3-Oct-16​
15​	4-Oct-16​	100​
16​	4-Oct-16​	1​
17​	4-Oct-16​	2​
18​	4-Oct-16​	2​
19​	5-Oct-16​	3​
20​	5-Oct-16​	3​
21​	5-Oct-16​	3​
22​	5-Oct-16​	3​
23​	5-Oct-16​	4​

<tbody>
</tbody>

g1=SUM(IF(FREQUENCY(IF($A$1:$A$23=E1,IF($B$1:$B$23<>"",$B$1:$B$23)),$B$1:$B$23),1)) control +shift+enter copy down

After you type in the formula, don't just press enter.
Instead, press CTRL + SHIFT + ENTER


If you've already entered the formula, then highlight the cell with the formula and press F2.
Then press CTRL + SHIFT + ENTER