+ Reply to Thread
Results 1 to 5 of 5

Dynamic calculations according to user input

  1. #1
    David
    Guest

    Dynamic calculations according to user input

    Hello,

    I built an excel application.

    In worksheet #1
    Each row contains a unique name like: David, Joe etc. (in column A) and
    it's data like: salary etc. (in columns B,C etc.). Last column contains
    unique groupName like group1, group2 etc.

    In worksheet #2
    Each row contains a unique group name like: group1, group2 etc. (in
    column A) and calculated data like: groupAverageSalary etc. (in columns
    B,C etc.)

    My problem is:
    In worksheet#2 I want to calaculate group's data dynamic according to
    user input in worksheet#1 (For example: groupAverageSalary for group1
    will be calculated as the average salary of all the people who are
    members in group1).

    worksheet #1
    Name, salary, ..., groupName
    David, 2000$, ..., group1
    Joe, 1000$, ..., group2

    worksheet #2
    groupName, averageSalary, ...
    group1, 2000$, ...
    group2, 1000$, ...

    Thank you
    David


  2. #2
    Vacation's Over
    Guest

    RE: Dynamic calculations according to user input

    formulas inExcel can "pull" from other sheets, just use exclamation point
    after sheet name

    =sum(sheet1!A4:a32)

    "David" wrote:

    > Hello,
    >
    > I built an excel application.
    >
    > In worksheet #1
    > Each row contains a unique name like: David, Joe etc. (in column A) and
    > it's data like: salary etc. (in columns B,C etc.). Last column contains
    > unique groupName like group1, group2 etc.
    >
    > In worksheet #2
    > Each row contains a unique group name like: group1, group2 etc. (in
    > column A) and calculated data like: groupAverageSalary etc. (in columns
    > B,C etc.)
    >
    > My problem is:
    > In worksheet#2 I want to calaculate group's data dynamic according to
    > user input in worksheet#1 (For example: groupAverageSalary for group1
    > will be calculated as the average salary of all the people who are
    > members in group1).
    >
    > worksheet #1
    > Name, salary, ..., groupName
    > David, 2000$, ..., group1
    > Joe, 1000$, ..., group2
    >
    > worksheet #2
    > groupName, averageSalary, ...
    > group1, 2000$, ...
    > group2, 1000$, ...
    >
    > Thank you
    > David
    >
    >


  3. #3
    David
    Guest

    Re: Dynamic calculations according to user input

    Heloo,

    Thank you for your answer.

    My problem is that each time I have to sum different rows.
    How can I sum only group members values ?

    Thank you
    David


  4. #4
    Executor
    Guest

    Re: Dynamic calculations according to user input

    Hi David,

    Look for the
    =SumIf(sheet1!F2:F32, A2, shee1!:B2:B32) function)
    Assuming column F on sheet1 hold group1, group2, ....


    HTH
    Wouter.


  5. #5
    David
    Guest

    Re: Dynamic calculations according to user input

    Thank you very much for your help.

    The SumIf function solved my problem.

    David


+ 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