Thread: Formula Question IF/Lookup????

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

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



"Hague2" <Hague2@discussions.microsoft.com> wrote in message
news:4A0B8288-8968-4E3F-BE29-7EA9A3281A2A@microsoft.com...
> 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

one way:

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

In article <4A0B8288-8968-4E3F-BE29-7EA9A3281A2A@microsoft.com>,
Hague2 <Hague2@discussions.microsoft.com> 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