Formula required
 

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

Formula required
 

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)



On Jun 26, 5:23*pm, Dimitri wrote:
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

Formula required
 

Hi Dimtri...

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

"Dimitri" wrote:

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