Formula Question IF/Lookup????

H

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top