Formula required

[Dimitri]

Hello:

On a seperate spredsheet I have created a synopsis but am having to enter
the information manually. Was hoping to do the following through a formula:

If anything in A1:A9 = 1 - on the seperate sheet would like a formula to
pick up the subsequent data in column B. (Ex. A1=1, B1=$100,000, A2=0,
B2=$5,000 and so on - the total on the seperate sheet should be $100,000)

Column A Column B
1 1 $100,000
2 0 $5,000
3 1 $6,000
4 1 $20,000
5 0 $5,000
6 1 $10,000
7 1 $5,000
8 0 $5,000
9 1 $5,000

Dimitri

 

[Tim879]

Try using the sumif function... like below.... assumes the data is on
a tab called sheet 2

=sumif(sheet2!A1:A9,1,Sheet2!b1:b9)

 

[About display names]

Hi Dimtri...

If you could send me a sample copy of your requirement to my id
([email protected]) i'll set a formula for you to automatically pick up
the amount from the first Sheet in the second sheet.