Results 1 to 7 of 7

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Registered User kVE's Avatar
    Join Date: Dec:2006
    Location: Bulgaria :-)
    Posts: 125

    Excel - êàê äà íàïðàâÿ òàáëèöà êîÿòî äà ñìÿòà?

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

    çàõàð - 1 ëâ
    îëèî - 1 ëâ
    îðèç - 2 ëâ


    | Îáùî = 4ëâ |

    ïðîñòî èñêàì ïðîãðàìàòà äà ìè ñìÿòà îáùèÿ ðåçóëòàò ñ öåë äà ñå óëåñíÿâàì àç.

  2. #2
    Banned all's Avatar
    Join Date: Feb:2003
    Location: Sofia
    Posts: 6,980
     êëåòêàòà, â êîÿòî î÷àêâåø ðåçóëòàòà íàïèøè òîâà:

    =SUM(A1,A2,A3,B1:B5)

    A1,A2,A3 ñà îòäåëíè êëåòêè
    B1:B5 ñà âñè÷êè êëåòêè îò B1 äî Â5
    â òîçè ïðèìåð ùå òè ñúáåðå ïúðâèòå 3 ðåäà îò êîëîíà À è ïúðâèòå 5 ðåäà îò êîëîíà Â

  3. #3
    Registered User kVE's Avatar
    Join Date: Dec:2006
    Location: Bulgaria :-)
    Posts: 125
    À Ìåðñè ïðèÿòåë æèâ è çäðàâ äà ñè ìíîãî ìè ïîìîãíà. õóáàâ äåí

  4. #4
    Ìúðçåëèâ ïàðàçèò worldoftanks's Avatar
    Join Date: Nov:2010
    Location: Ñòàðà Çàãîðà
    Posts: 3,203
    Quote Originally Posted by all View Post
     êëåòêàòà, â êîÿòî î÷àêâåø ðåçóëòàòà íàïèøè òîâà:

    =SUM(A1,A2,A3,B1:B5)
    Äàíî äà íå èçãëåæäà êàòî çàÿæäàíå, íî â Åêñåë îòäåëíèòå îáëàñòè ñå ðàçäåëÿò ñ ; à íå , ò.å. ãîðíèÿ ïðèìåð áè òðÿáâàëî äà èçãëåæäà òàêà
    =SUM(A1;A2;A3;B1:B5)

  5. #5
    Registered User
    Join Date: Aug:2009
    Location: Ñîôèÿ
    Posts: 265
    Quote Originally Posted by worldoftanks View Post
    Äàíî äà íå èçãëåæäà êàòî çàÿæäàíå, íî â Åêñåë îòäåëíèòå îáëàñòè ñå ðàçäåëÿò ñ ; à íå , ò.å. ãîðíèÿ ïðèìåð áè òðÿáâàëî äà èçãëåæäà òàêà
    =SUM(A1;A2;A3;B1:B5)
    Òîâà çàâèñè îò ðåãèîíàëíèòå íàñòðîéêè.

  6. #6
    Ìúðçåëèâ ïàðàçèò worldoftanks's Avatar
    Join Date: Nov:2010
    Location: Ñòàðà Çàãîðà
    Posts: 3,203
    Quote Originally Posted by Avis View Post
    Òîâà çàâèñè îò ðåãèîíàëíèòå íàñòðîéêè.
    Ëèíê?

    Ï.Ï. Íàìåðèõ ñè ñàì, òàêà å.

    Âñå ïîâå÷å ñå óáåæäàâàì, ÷å Åêñåë (êàêòî è ïîâå÷åòî ïðîäóêòè íà MS) å ìíîãî ñêàïàíà ïðîãðàìà.

  7. #7
    Chalgakiller Svilen Zhelev's Avatar
    Join Date: Jan:2004
    Location: BG
    Posts: 266
    Èëè ìàðêèðàø êëåòêèòå è íàòèñêàø áóòîíúò "Σ Autosum".

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