Results 1 to 3 of 3

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Registered User
    Join Date: Dec:2005
    Location: Bulgaria
    Posts: 4

    Ôîðìóëà íà Åêñåë

    Çäðàâåéòå,

    Èìàì åäèí sheet â Excel êîéòî â åäíà êîëîíêà èìàì åãí-òà íà êëèåíòè à â ñëåäâàøàòà êîëîíêà ñóìàòà íà ïîêóïêàòà êîÿòî ñà íàïðàâèëè, êàòî äàäåí êëèåíò ìîæå äà ñå ïîâòîðè íÿêîëêî ïúòè ñ ðàçëè÷íè ñóìè. Âúçìîæíî ëè å â 2-ðè sheet ÷ðåç ôîðìóëà äà ñúáåðà îáùàòà ñóìà íà äàäåí êëèåíò? Çíàì çà ôîðìóëàòà vlookup ÷å òúðñè è èçêàðâà èíôîðìàöèÿ ïî äàäåí ïàðàìåòúð íî ÿâíî ñ íåÿ íåìîãà äà ñúáåðà ñóìàòà. Áëàãîäàðÿ íà âñè÷êè îòçîâàëè ñè.

  2. #2
    Executor Lan's Avatar
    Join Date: Nov:2005
    Location: Ñîôèÿ
    Posts: 3,304
    Ðàçãëåäàëè SUMIF ?
    I mourn thee by dusk | I mourn thee by dawn
    Crave for thy gloss | to seek the silent glades beyond

  3. #3
    Registered User
    Join Date: Dec:2005
    Location: Bulgaria
    Posts: 4
    äà ñòàíà áëàãîäàðÿ òè ìíîãî

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