Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
try
=SUMPRODUCT(--(--A1:A10=1),B1:B10) "Hague2" wrote in message ... 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 |
#3
|
|||
|
|||
one way:
=SUMIF(A:A,1,B:B) In article , Hague2 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula Question...PLEASE PLEASE help! | Excel Worksheet Functions | |||
Lookup/Index formula question. | Excel Worksheet Functions | |||
Parsing Data w/ a Formula (another question) | Excel Worksheet Functions | |||
Formula Question | Excel Worksheet Functions | |||
SUM array formula question | Excel Worksheet Functions |