How to select numbers and add together on another sheet 1

[leehale]

I am doing a sheet that will measure capacity on a production plan, I want to take the totals from selected cells and add them together in one cell on another sheet, can you help me with this, here is a sample line of the sheet..
TYPE MCN REQ TIME/MINS
20x121 300 150 6.00
12345 300 2000 5.00
34561 310 600 4.00
54321 330 500 7.00

On another sheet in one cell add the machine times for the 300 machine, The result would be 11.00 mins, does that make sense?

 

[Hasit]

leehale, use Conditional Sum. If you click on
TOOLS->WIZARD, select the CONDITIONAL SUM option. If it does not appear there, then you will need to add it.

To add it, click on TOOLS->ADD-IN and select the CONDITIONAL SUM WIZARD.

Then follow the prompts in the wizard.

For your information, I used the data you supplied above, and assuming that the the top left of the data above sat in A1 and then downwards and across, the formula (using conditional sum) to get the answer for the 300 machine is:

{=SUM(IF(Sheet1!$B$2:$B$5=300,Sheet1!$D$2:$D$5,0))}

I put that formula in A1 on sheet 2 and got the 11minutes you are looking for. Note that when you select the range that the conditional sum wizard looks at, you MUST include heading names as you have done in your example above.