Results 1 to 2 of 2
Thread: Ôîðìóëà â Excel
Hybrid View
-
14th June 2008 17:47 #1
Ôîðìóëà â Excel
Èìà ìå ñëåäíèòå ðåäîâå:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
Êàêâà ùå å ôîðìóëàòà ñúñ COUNT çà äà ìîãà äà ïðåáðîÿ ñàìî òåçè, êîèòî ñà ïî ãîëåìè îò 5
Òîåñò êðàéíèÿ ðåçóëòàò òðÿáâà äà áúäå "10".
Ìîëÿ ïîìîãíåòå ñïåøíî å. Áëàãîäàðÿ ïðåäâàðèòåëíî!
-
14th June 2008 18:07 #2Banned
Join Date: May:2008
Location: Âàðíà
Posts: 51
Òðÿáâà äà ñå èçïîëçâà COUNTIF. Àêî ÷èñëàòà ñà ðàçïîëîæåíè îò À1 äî À15, ôîðìóëàòà èìà ñëåäíèÿ âèä :
=COUNTIF(A1:A15;">5")




Reply With Quote
Lenovo ThinkPad 15 èëè IdeaPad 15
5th May 2023, 22:16 in Ìîáèëíè êîìïþòðè