# Excel how to add a multiple "name" cell with is calculation to a cell on a separate page **URL:** \ **Category:** Factual Questions\ **Created:** [May 6, 2012, 12:36pm UTC](https://boards.straightdope.com/t/excel-how-to-add-a-multiple-name-cell-with-is-calculation-to-a-cell-on-a-separate-page/621060 "2012-05-06T12:36:20Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![tamhav](https://avatars.discourse-cdn.com/v4/letter/t/e68b1a/32.png) [@tamhav](https://boards.straightdope.com/u/tamhav)\ **Post date:** [May 6, 2012, 12:36pm UTC](https://boards.straightdope.com/t/excel-how-to-add-a-multiple-name-cell-with-is-calculation-to-a-cell-on-a-separate-page/621060/1 "2012-05-06T12:36:20Z")
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 ---
**Author:** ![Zakalwe](https://sea3.discourse-cdn.com/straightdope/user_avatar/boards.straightdope.com/zakalwe/32/270_2.png) [@Zakalwe](https://boards.straightdope.com/u/Zakalwe)\ **Post date:** [May 6, 2012, 12:51pm UTC](https://boards.straightdope.com/t/excel-how-to-add-a-multiple-name-cell-with-is-calculation-to-a-cell-on-a-separate-page/621060/2 "2012-05-06T12:51:23Z")
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. ---
**Author:** ![tamhav](https://avatars.discourse-cdn.com/v4/letter/t/e68b1a/32.png) [@tamhav](https://boards.straightdope.com/u/tamhav)\ **Post date:** [May 6, 2012, 1:05pm UTC](https://boards.straightdope.com/t/excel-how-to-add-a-multiple-name-cell-with-is-calculation-to-a-cell-on-a-separate-page/621060/3 "2012-05-06T13:05:42Z")
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 ---
**Author:** ![tamhav](https://avatars.discourse-cdn.com/v4/letter/t/e68b1a/32.png) [@tamhav](https://boards.straightdope.com/u/tamhav)\ **Post date:** [May 6, 2012, 1:16pm UTC](https://boards.straightdope.com/t/excel-how-to-add-a-multiple-name-cell-with-is-calculation-to-a-cell-on-a-separate-page/621060/4 "2012-05-06T13:16:09Z")
thanks zakalwe the last sum worked!!! clearly i can make anything easy look amazingly difficult! ---
**Author:** ![Zakalwe](https://sea3.discourse-cdn.com/straightdope/user_avatar/boards.straightdope.com/zakalwe/32/270_2.png) [@Zakalwe](https://boards.straightdope.com/u/Zakalwe)\ **Post date:** [May 6, 2012, 1:37pm UTC](https://boards.straightdope.com/t/excel-how-to-add-a-multiple-name-cell-with-is-calculation-to-a-cell-on-a-separate-page/621060/5 "2012-05-06T13:37:28Z")
Glad to help! ---
**Author:** ![K364](https://sea3.discourse-cdn.com/straightdope/user_avatar/boards.straightdope.com/k364/32/5_2.png) [@K364](https://boards.straightdope.com/u/K364)\ **Post date:** [May 6, 2012, 5:57pm UTC](https://boards.straightdope.com/t/excel-how-to-add-a-multiple-name-cell-with-is-calculation-to-a-cell-on-a-separate-page/621060/6 "2012-05-06T17:57:42Z")
Pivot tables are very good for this type of problem.