Tarİhe göre kaç negatİf var kaç pozİtİf var İçİn hangİ formülü kullanabİlİrİm
Tarİhe göre kaç negatİf var kaç pozİtİf var İçİn hangİ formülü kullanabİlİrİm
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.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
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
In the workbook, please.
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)
Yenİ örnek
See post #4.
=ÇOKEĞERSAY($B$2:$B$18;$K3;$C$2:$C$18;L$2)
örnek dosyaya eklermİsİnİz?
You can do that yourself. See post #7 - copy and paste it into cell L3, then copy across and down.
Kopyaladim yapiŞtirdim. Hata verİyor!
What error?
5 numaradakİ kopyalamiŞim. özür. Düzüldİ. TeŞekürler.
Great.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks