Results 1 to 12 of 12

Thread: Excel formula pomoc

  1. #1
    Join Date
    May 2007
    Location
    Tv
    Posts
    22,842
    Thanks Thanks Given 
    3,157
    Thanks Thanks Received 
    5,516
    Thanked in
    2,233 Posts

    Default Excel formula pomoc

    Dakle...

    Treba mi formula koja ce da mi da sumu prihoda za odredjeni market(nazovimo ga PRO). Posto iznosi nisu u koloni jedan za drugim na dolje, ne mogu samo da povucem put dolje i da dobijem sumu svih zaredom... Ako bih celije oznacavao jednu po jednu trebalo bi mi maaasu vremena...

    Mogu li neku LOOKUP formulu da koristim ili kako...?

    Sent from my Mi 9T using Tapatalk

  2. #2
    Join Date
    Jan 2004
    Location
    Montenegro, Podgorica, Centar
    Posts
    13,450
    Thanks Thanks Given 
    3,807
    Thanks Thanks Received 
    3,057
    Thanked in
    1,297 Posts

    Default

    Quote Originally Posted by Mojsije View Post
    Dakle...

    Treba mi formula koja ce da mi da sumu prihoda za odredjeni market(nazovimo ga PRO). Posto iznosi nisu u koloni jedan za drugim na dolje, ne mogu samo da povucem put dolje i da dobijem sumu svih zaredom... Ako bih celije oznacavao jednu po jednu trebalo bi mi maaasu vremena...

    Mogu li neku LOOKUP formulu da koristim ili kako...?

    Sent from my Mi 9T using Tapatalk
    Ako te ja dobro kapiram, treba ti sumif funkcija... Ili ne, jer ti nije tabela ovako koncipirana?
    Click image for larger version. 

Name:	CDM excel.jpg 
Views:	83 
Size:	8.6 KB 
ID:	169817
    Last edited by Ben Dover; 13-10-20 at 13:27.
    --------------->
    <---------------
    Odavde dovde...

  3. #3
    Join Date
    May 2007
    Location
    Tv
    Posts
    22,842
    Thanks Thanks Given 
    3,157
    Thanks Thanks Received 
    5,516
    Thanked in
    2,233 Posts

    Default

    Quote Originally Posted by Ben Dover View Post
    Ako te ja dobro kapiram, treba ti sumif funkcija... Ili ne, jer ti nije tabela ovako koncipirana?
    Click image for larger version. 

Name:	CDM excel.jpg 
Views:	83 
Size:	8.6 KB 
ID:	169817
    U sustini da... Imam recimo

    PRO
    PRO2
    .....
    .....
    .....
    .....
    PRO
    PRO2
    .......
    ......
    ......
    PRO
    PRO2
    .......


    Znaci treba mi funkcija koja ce mi sabrati PRO i PRO2 vrijednosti... kako?

  4. #4
    Join Date
    Jan 2004
    Location
    Montenegro, Podgorica, Centar
    Posts
    13,450
    Thanks Thanks Given 
    3,807
    Thanks Thanks Received 
    3,057
    Thanked in
    1,297 Posts

    Default

    Onda ti sumif moze valjati. Unesi je gore u polje formule, i onda definises kolonu dje su ti PRO-ovi, pa postavis kriterijum PRO i onda kolonu dje su ti iznosi i sabrace ti samo za PRO
    Click image for larger version. 

Name:	CDM excel1.jpg 
Views:	74 
Size:	12.1 KB 
ID:	169818
    --------------->
    <---------------
    Odavde dovde...

  5. The Following User Says Thank You to Ben Dover For This Useful Post:


  6. #5
    Join Date
    Jan 2004
    Posts
    2,059
    Thanks Thanks Given 
    200
    Thanks Thanks Received 
    221
    Thanked in
    112 Posts

    Default

    Bez formula dodaj jednu pivot tabelu.
    Ako ćeš sumif, izvuci pojedniačne nazive kojima ćeš dodati sumif.
    Ako se ne snadjes salji fajl na pp.

  7. The Following User Says Thank You to Mr_G_rUzNi For This Useful Post:


  8. #6
    Join Date
    Jan 2004
    Posts
    36,764
    Thanks Thanks Given 
    88
    Thanks Thanks Received 
    3,265
    Thanked in
    1,814 Posts

    Default

    Ja to radim preko filtera.
    Filter na Pro1 i SUM.
    Dva klika


    Poslato sa ultra moderne pisaće mašine Note X
    ............ Ż\_(ツ )_/Ż.............
    -> Forma za naručivanje online stvari <-

    Bugi Vugi tapši Raduj se!

  9. #7
    Join Date
    May 2007
    Location
    Tv
    Posts
    22,842
    Thanks Thanks Given 
    3,157
    Thanks Thanks Received 
    5,516
    Thanked in
    2,233 Posts

    Default

    Quote Originally Posted by Bugi View Post
    Ja to radim preko filtera.
    Filter na Pro1 i SUM.
    Dva klika


    Poslato sa ultra moderne pisaće mašine Note X
    ............ Ż\_(ツ )_/Ż.............
    Ne moze tako jer nisu sve vrijednosti jedne ispod drugih. Ja sam to prvo s filterom probao, ali sam vidio da SUM uzima vrijednost i onih celija koje se ne vide.

    Za sad sam se snasao, pa cemo da vidimo kako ce dalje ici



    Sent from my Mi 9T using Tapatalk

  10. #8
    Join Date
    Jan 2004
    Posts
    36,764
    Thanks Thanks Given 
    88
    Thanks Thanks Received 
    3,265
    Thanked in
    1,814 Posts

    Default

    Baš ne mogu da zamislim tu tabelu...
    I zašto je sve tako? Je li to neki izvještaj ili?


    Poslato sa ultra moderne pisaće mašine Note X
    ............ Ż\_(ツ )_/Ż.............
    -> Forma za naručivanje online stvari <-

    Bugi Vugi tapši Raduj se!

  11. #9
    Join Date
    Jan 2004
    Posts
    2,059
    Thanks Thanks Given 
    200
    Thanks Thanks Received 
    221
    Thanked in
    112 Posts

    Default

    @Bugi mislim da nema samo Pro, Pro2, već i Pro3, Pro4, ma Pro(n+1)

  12. #10
    Join Date
    Jan 2004
    Posts
    36,764
    Thanks Thanks Given 
    88
    Thanks Thanks Received 
    3,265
    Thanked in
    1,814 Posts

    Default

    Pivot table


    Poslato sa ultra moderne pisaće mašine Note X
    ............ Ż\_(ツ )_/Ż.............
    -> Forma za naručivanje online stvari <-

    Bugi Vugi tapši Raduj se!

  13. The Following User Says Thank You to Bugi For This Useful Post:


  14. #11
    Join Date
    May 2007
    Location
    Tv
    Posts
    22,842
    Thanks Thanks Given 
    3,157
    Thanks Thanks Received 
    5,516
    Thanked in
    2,233 Posts

    Default

    Quote Originally Posted by Bugi View Post
    Baš ne mogu da zamislim tu tabelu...
    I zašto je sve tako? Je li to neki izvještaj ili?


    Poslato sa ultra moderne pisaće mašine Note X
    ............ Ż\_(ツ )_/Ż.............
    Radim ekstrakciju podataka iz sistema u delimited data formatu, pa onda taj txt dokument importujem u excel. Zatim mapiram formule sa podacima koji su mi neophodni, kako bih napravio neke analize i izvjestaje... ovi delimited data izvjestaji koje ja vadim su bas sa milijardu podataka, zato i trazim nacine kako da sve vrijednosti za trazene parametre pronadjem i izracunam... evo sad gledam pivot tabele

  15. #12
    Join Date
    Apr 2007
    Location
    White Sandy Beach
    Posts
    8,876
    Thanks Thanks Given 
    234
    Thanks Thanks Received 
    47
    Thanked in
    31 Posts

    Default





    =SUMIF(A1:A9,"*pro*",B1:B9)
    A ako se samo sufixno mijenja, onda makni prvu zvjezdicu
    Attached Thumbnails Attached Thumbnails Click image for larger version. 

Name:	forum 1.jpg 
Views:	36 
Size:	2.8 KB 
ID:	169827  
    Last edited by St.Dzonny; 14-10-20 at 00:07.

  16. The Following User Says Thank You to St.Dzonny For This Useful Post:


Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Excel - pomoc
    By gigabyte in forum Software
    Replies: 15
    Last Post: 11-12-12, 16:38
  2. Pomoc excel
    By EOPOMALO in forum Software
    Replies: 21
    Last Post: 26-02-11, 21:02
  3. "Excel" pomoc
    By cpu in forum Software
    Replies: 2
    Last Post: 14-11-08, 21:15
  4. Pomoc sa Excel formulom
    By Rincewind in forum Software
    Replies: 5
    Last Post: 20-08-08, 09:48
  5. mala pomoc oko excel-a
    By funky^junkie in forum Software
    Replies: 5
    Last Post: 28-01-07, 10:06

Bookmarks

Bookmarks

Posting Permissions

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