Results 1 to 15 of 15

Needed: Calculation formule with different columns

Threaded View

  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.

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