column formulas

[kimberann13]

Ok,someone told me that you can enter in a formula for an ENTIRE column and it will auto-compute for every cell in the column?? TRUE???

I have 2 columns of dates (start date, end date) and I want to figure the #of days between (easy!!! =b-a) BUT I have some in the end date that are empty and I do not want a big neg. number to show in the # of day between cell.........

any suggestions????

 

[Von Pookie]

Assuming the End dates are in column B:

=IF(B2="","",B2-A2)

 

[kimberann13]

AWESOME!!

thanks!!! that works great.....

But have you heard of a formula you only enter ONCE and it will apply to the entire column???

 

[Von Pookie]

Oh. You have to select all of the cells you want it to go into, first.

So, select C1:C10. With all of the cells still selected, start typing the formula. Then press Ctrl+Enter and the formula (or anything else you entered) will be put into all of the highlighted cells.

Edit: Or, I guess just enter it into C1 and fill down. Either way, you have to tell it where to go somehow

 

[kimberann13]

thanks again

thanks again!!!! your grrrrrreat :wink:

 

[barry houdini]

Re: AWESOME!!

But have you heard of a formula you only enter ONCE and it will apply to the entire column???

try this

=SUMPRODUCT(--(A2:A10<>""),--(B2:B10<>""),--(B2:B10-A2:A10))

adjust ranges as necessary