Formula Question IF/Lookup????

[Hague2]

I need help with a formula. I have a column with 0's or 1's in each cell.
The column to the right of this has numbers in it. I want to get the total
results of the cells to the right of 1's only? I know I can use an IF
statement for the first column, IF 0 do this, IF 1 do that. But how do I
pull the information from the cell to the right of all the 1's in the column?
Thanks

[Dave R.]

try
=SUMPRODUCT(--(--A1:A10=1),B1:B10)



"Hague2" <[email protected]> wrote in message
news:[email protected]...
> I need help with a formula. I have a column with 0's or 1's in each cell.
> The column to the right of this has numbers in it. I want to get the
total
> results of the cells to the right of 1's only? I know I can use an IF
> statement for the first column, IF 0 do this, IF 1 do that. But how do I
> pull the information from the cell to the right of all the 1's in the
column?
> Thanks

[JE McGimpsey]

one way:

=SUMIF(A:A,1,B:B)

In article <[email protected]>,
Hague2 <[email protected]> wrote:

> I need help with a formula. I have a column with 0's or 1's in each cell.
> The column to the right of this has numbers in it. I want to get the total
> results of the cells to the right of 1's only? I know I can use an IF
> statement for the first column, IF 0 do this, IF 1 do that. But how do I
> pull the information from the cell to the right of all the 1's in the column?
> Thanks