| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Is it possible ?
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Is it possible ?
THANKS MAN ! THAT WORKED PERFECTLY
"jlclyde" wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
