Dynamic calculations according to user input

[David]

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

 

[Guest]

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

=sum(sheet1!A4:a32)

 

[David]

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

 

[Executor]

Hi David,

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


HTH
Wouter.

 

[David]

Thank you very much for your help.

The SumIf function solved my problem.

David