On Jan 9, 10:47*am, Is it possible ? <Is it
possible wrote:
okey here is what i want to do i dont know if it is possible or not

I have a column that starts from F5 to F30
this column has some numbers in it
the number is either 1 or 2

i want to see
IF F5 = 1
ADD H5 TO WHATS IN J5

AND TO CHECK THE REST OF THE COLUMN FROM F5 TO F30

This is not entirely clear on what youw ant to do. To do the first
part it is =IF(F5=1,H5+J5,""). I am not sure what you men by checking
the rest of the row. Do you mean to do this line by line? If so then
just copy down the formula. If you mean check the rest of the row and
add them together, then youcoudl use SUMIF or SUMPRODUCT.

Jay