Tarİhe göre negatİf ve pozİtİf sayi formulu

[gogo0505]

Tarİhe göre kaç negatİf var kaç pozİtİf var İçİn hangİ formülü kullanabİlİrİm

[AliGW]

What are you expecting to see here?

Excel 2016 (Windows) 32 bit

	K	L	M
2		NEGATIF	POZITIF
3	25/02/2020
4	27/02/2020
5	28/02/2020
6	01/03/2020
7	03/03/2020
8	04/03/2020
9	05/03/2020
10	06/03/2020
11	10/03/2020
12	11/03/2020

Sheet: Sayfa1

Please fill in the grid MANUALLY with the results you are looking for, then post the workbook again.

[gogo0505]

Negatİf pozİtİf
25.02.2020 1 0
27.02.2020 1 0
28.02.2020 1 0
1.03.2020 0 1
3.03.2020 1 0
4.03.2020 1 0
5.03.2020 4 1
6.03.2020 0 4
10.03.2020
11.03.2020

[AliGW]

In the workbook, please.

[AliGW]

Maybe this?

In L3 copied across and down:

=COUNTIFS($B$2:$B$18,$K3,$C$2:$C$18,L$2)

For your locale:

=COUNTIFS($B$2:$B$18;$K3;$C$2:$C$18;L$2)

[gogo0505]

Yenİ örnek

[AliGW]

See post #4.

=ÇOKEĞERSAY($B$2:$B$18;$K3;$C$2:$C$18;L$2)

[gogo0505]

örnek dosyaya eklermİsİnİz?

[AliGW]

You can do that yourself. See post #7 - copy and paste it into cell L3, then copy across and down.

[gogo0505]

Kopyaladim yapiŞtirdim. Hata verİyor!

[AliGW]

What error?

[gogo0505]

5 numaradakİ kopyalamiŞim. özür. Düzüldİ. TeŞekürler.

[AliGW]

Great.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.