Excel how to add a multiple "name" cell with is calculation to a cell on a separate page

[tamhav]

Ok hi guys,

Ive only opened my eyes to the potential of excel recently, but now im stuck on a formula (please note i dont know correct terms to use - sorry if it gets confusing like that)

ok i have a drop down boxs, lets call the names in them product 1, product 2, product 3 etc (in cells E18 - E28)... if u chose a product it automatically spits out a formula in cell G (so G18-G28 all the same formula)

now i need on a seperate sheet, to calculate how many times "product 1" (E cells) + its formula (in G cells) total too.

sheez im sure i make it sound allot more complicated that it is but i need help

thanks guys/girls

[Zakalwe]

It might be better if you put a little more detail in, I'm not sure I completely follow you, but if I understand you correctly, the formulas you are looking for are:

COUNTIF(range, criteria)
and
SUMIF(checkrange,criteria,sumrange)

So, on your other tab:

COUNTIF('Sheet1'!E18:E28,"Product1")
repeat as necessary for Product2-ProductN

SUMIF('Sheet1'!E18:E28,"Product1",'Sheet1'!G18:G28)
again repeat as necessary.

[tamhav]

Ok i will try explain

On sheet one i have in Row B ,codes in drop down boxes - this pushes out name etc into row C + D and their salaries automatically will go into Row F, in row G is there overtime hours worked.

In row E i have a drop down box as to where the staff worked. (eg SOUTH AFRICA)

Now what i would like on sheet two is to make a analysis for say SOUTH AFRICA - a calculation of everytime it was used in the drop down box + the amount of overtime on that row it calculated - all added up.

This is so hard to put in words sorry
but thanks for the quick reply

[tamhav]

thanks zakalwe

the last sum worked!!!
clearly i can make anything easy look amazingly difficult!

[Zakalwe]

Glad to help!

[K364]

Pivot tables are very good for this type of problem.