+ Reply to Thread
Results 1 to 15 of 15

Needed: Calculation formule with different columns

  1. #1
    Registered User
    Join Date
    12-28-2012
    Location
    Holland
    MS-Off Ver
    Excel 2003
    Posts
    7

    Needed: Calculation formule with different columns

    Dear everyone,

    First of all thanks alot for helping!
    I have already alot of data in my excel form, now i am creating a new colom in which I want to calculate some data from other colums.

    Let me draw a small sketchs as example:
    A B C
    1 1 848 (All data which belong to the category A=1 (all numbers from B who belong to an 1 @ A)
    2 1 343
    3 1 234
    4 2 232
    5 2 45
    6 2 567
    7 2 565
    8 3 920
    9 3 842
    10 3 34

    My question is, what is the formula for C in order to save me alot of time in doing it by hand?
    Sorry for my bad explenation, and my even worse english. I hope some1 can help me, thanks alot!!

    Kind regards, Elmer
    Last edited by Elmerf; 12-28-2012 at 03:20 PM.

  2. #2
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: Pretty basic calculation formula but i forgot it :P

    Hi elmerf,

    Welcome to the forum.

    Is there any logic / equation for C column results basis A & B ?

    Regards,
    DILIPandey
    <click on below * if this helps>
    DILIPandey
    +91 9810929744
    dilipandey@gmail.com

  3. #3
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    51,801

    Re: Pretty basic calculation formula but i forgot it :P

    Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
    To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  4. #4
    Registered User
    Join Date
    12-28-2012
    Location
    Holland
    MS-Off Ver
    Excel 2003
    Posts
    7

    Re: Pretty basic calculation formula but i forgot it :P

    Hey, thank you!

    Well it is all about orders.

    Column A: What day did the order came in?
    Column B: What is the amount of this specific order?

    Now I am trying to set up column c:
    Column C: What is the total amount of orders per day

  5. #5
    Registered User
    Join Date
    05-27-2012
    Location
    Bangalore
    MS-Off Ver
    Excel 2007
    Posts
    52

    Re: Needed: Calculation formule with different columns

    Quote Originally Posted by Elmerf View Post
    Dear everyone,

    First of all thanks alot for helping!
    I have already alot of data in my excel form, now i am creating a new colom in which I want to calculate some data from other colums.

    Let me draw a small sketchs as example:
    A B C
    1 1 848 (All data which belong to the category A=1 (all numbers from B who belong to an 1 @ A)
    2 1 343
    3 1 234
    4 2 232
    5 2 45
    6 2 567
    7 2 565
    8 3 920
    9 3 842
    10 3 34

    My question is, what is the formula for C in order to save me alot of time in doing it by hand?
    Sorry for my bad explenation, and my even worse english. I hope some1 can help me, thanks alot!!

    Kind regards, Elmer
    Hi Elmer,

    Could you please attach a sample file and your requirment in an excel file so that I can have a look at it before I could suggest something?

    Regards,
    Kiran

  6. #6
    Registered User
    Join Date
    12-28-2012
    Location
    Holland
    MS-Off Ver
    Excel 2003
    Posts
    7

    Re: Needed: Calculation formule with different columns

    excel opzetje.xlsx

    Hope this works, ask me if you need to know anything! Thanks for looking at it!

  7. #7
    Registered User
    Join Date
    12-28-2012
    Location
    Holland
    MS-Off Ver
    Excel 2003
    Posts
    7

    Re: Needed: Calculation formule with different columns

    I need something like:

    =Amount(B;1) or something as a start.
    Then next to thati need something like
    =SUM;E(B;$1)

    Something like that but i forgot the exact one:p

  8. #8
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: Needed: Calculation formule with different columns

    not sure.. can you manually put in few results and will try to obtain the same using formula . thanks.

    Regards,
    DILIPandey
    <click on below * if this helps>

  9. #9
    Registered User
    Join Date
    05-27-2012
    Location
    Bangalore
    MS-Off Ver
    Excel 2007
    Posts
    52

    Re: Needed: Calculation formule with different columns

    see if this what you were looking for....
    let me know if this helps...
    Attached Files Attached Files

  10. #10
    Registered User
    Join Date
    12-28-2012
    Location
    Holland
    MS-Off Ver
    Excel 2003
    Posts
    7

    Re: Needed: Calculation formule with different columns

    Yes! That is the correct answer indeed! How did you do that, I do understand your code but how do I fill it in for all?

  11. #11
    Registered User
    Join Date
    05-27-2012
    Location
    Bangalore
    MS-Off Ver
    Excel 2007
    Posts
    52

    Re: Needed: Calculation formule with different columns

    a better idea would be to do a pivot to see the sum of order amounts for each of the order dates.
    I have shown it on "Sum of order amounts" tab on the attachment
    Attached Files Attached Files

  12. #12
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    Excel 2010 on Linux - O365
    Posts
    12,509

    Re: Needed: Calculation formule with different columns

    In I7 perhaps
    Please Login or Register  to view this content.
    then double click the handle at the lower right corner of the cell A pivot table will also be possible
    I'm a newbie with PQ, so if my solution can be improved, please let me know. Thanks

  13. #13
    Registered User
    Join Date
    12-28-2012
    Location
    Holland
    MS-Off Ver
    Excel 2003
    Posts
    7

    Re: Needed: Calculation formule with different columns

    Wow nice, thanks alot! That is the info I needed most
    Thank alot man.

  14. #14
    Registered User
    Join Date
    05-27-2012
    Location
    Bangalore
    MS-Off Ver
    Excel 2007
    Posts
    52

    Re: Needed: Calculation formule with different columns

    Thanks Elmerf...
    click on the star mark if my solution helps you...

  15. #15
    Registered User
    Join Date
    12-28-2012
    Location
    Holland
    MS-Off Ver
    Excel 2003
    Posts
    7

    Re: Needed: Calculation formule with different columns

    I did Kiran, thanks alot Bye bye all the work is done now haha, have a nice weekend!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1