Results 1 to 4 of 4

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Registered User an4o_86's Avatar
    Join Date: Aug:2007
    Location: Sofia
    Posts: 23

    Âúïðîñ÷å çà Excel

    Çäðàâåéòå, èìàì åäèí ìàëêî ñòðàíåí âúïðîñ.Èìà ëè ôóíêöèÿ â Excel êîÿòî äà ïîêàçâà êîëêî îò ïîëåòàòà â äàäåíà êîëîíêà èëè ðåäèöà ñà ïîïúëíåíè...Íàäÿâàì ñå ÷å âúïðîñà ìè å äîñòàòú÷íî ÿñåí, áëàãîäàðÿ ïðåäâàðèòåëíî....

  2. #2
    Registered User Sko4a's Avatar
    Join Date: Sep:2007
    Location: Sofia
    Posts: 199
    COUNTIF, âàæíîòî å êàêúâ ùå òè áúäå àðãóìåíòà, ÷ðåç êîéòî ùå îòëè÷àâàø íåïîïúëíåíèòå êëåòêè. Íàïðèìåð àêî íåïîïúëíåíèòå ñà ïúëíè ñ íóëè, òî òîé ùå áúäå <>0.
    CPU: C2D E8400 + CoolerMaster Hyper 212 Plus | MB: Asus P5K | RAM: 4GB Transcend AxeRam | VC: Asus EAH4850 + AC Accelero S1 rev. 2 | Case: Antec SLK3000B | PSU: AC Fusion 550R | çâóê: Altec Lansing VS2421 (2.1)

  3. #3
    Çâåðî÷îâåêîïðèçðàê pimpirlit's Avatar
    Join Date: Mar:2004
    Location: Ñîôèÿ
    Posts: 21,712
    Ñ COUNTBLANK(range) ñòàâà ïî-ëåñíî.
    Æèâîòúò å õóáàâ!

  4. #4
    Registered User an4o_86's Avatar
    Join Date: Aug:2007
    Location: Sofia
    Posts: 23
    Thanks guys

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 | Ìàãàçèí çà åëåêòðîííè öèãàðè