Results 1 to 2 of 2

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Registered User MultiPlY's Avatar
    Join Date: Oct:2005
    Location: Varna
    Posts: 15

    Ôîðìóëà â Excel

    Èìà ìå ñëåäíèòå ðåäîâå:

    1
    2
    3
    4
    5
    6
    7
    8
    9
    10
    11
    12
    13
    14
    15


    Êàêâà ùå å ôîðìóëàòà ñúñ COUNT çà äà ìîãà äà ïðåáðîÿ ñàìî òåçè, êîèòî ñà ïî ãîëåìè îò 5

    Òîåñò êðàéíèÿ ðåçóëòàò òðÿáâà äà áúäå "10".

    Ìîëÿ ïîìîãíåòå ñïåøíî å. Áëàãîäàðÿ ïðåäâàðèòåëíî!

  2. #2
    Banned
    Join Date: May:2008
    Location: Âàðíà
    Posts: 51
    Òðÿáâà äà ñå èçïîëçâà COUNTIF. Àêî ÷èñëàòà ñà ðàçïîëîæåíè îò À1 äî À15, ôîðìóëàòà èìà ñëåäíèÿ âèä :

    =COUNTIF(A1:A15;">5")

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Copyright © 1999-2011 Õàðäóåð ÁÃ. Âúçìîæíî å ñúäúðæàíèåòî íà òàçè ñòðàíèöà äà å îáåêò íà àâòîðñêè ïðàâà.
iskamPC.com | mobility.BG | Bloody's Techblog | Êðèïòîâàëóòè è ìàéíèíã | 3D Vision Blog | Ìàãàçèí çà åëåêòðîííè öèãàðè