View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Marcelo Marcelo is offline
external usenet poster
 
Posts: 1,047
Default Is it possible ?

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:

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