Is it possible ?

  • Thread starter Is it possible ?
  • Start date
I

Is it possible ?

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
 
J

jlclyde

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
Click to expand...

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
 
M

Marcelo

why not use a another column to sum H5 and J5 with the formula:

=if(f5=1,(h5+j5),j5)

copy it down

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Is it possible ?" escreveu:
 
I

Is it possible ?

THANKS MAN ! THAT WORKED PERFECTLY

jlclyde said:
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
Click to expand...
 
Top