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

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

Dynamic calculations according to user input
 

Thank you very much for your help.

The SumIf function solved my problem.

David