working 2 functions into 1 cell

[theboykidney]

Hi,
I have a cell that is returning information from this function
=IF(COUNTA('job B'!N5:N23), 1, "")
which basically returns a 1 if there is any information in a range of cells.

I also have this function:
=1/COUNT(J31:W31)
which divides 1 by the number of cells that have content.

I need these 2 functions merged if possible into one function in a cell.
so the logic/example of it would be:
Check to see if there is any information in the specified range of cells, return a 1 if there is, nothing if there isn't. then looking in the rest of this column (which has the same function repeated), count how many cells have entries and divide 1 by that count.
The result will be a column of cells that will contain decimal numbers that add up to 1, dynamically changing if more entries are put in at the source.

any pointers?

Thanks a lot,
TBK.

 

[cjcobra]

IF(COUNTA('job B'!N5:N23), 1, 1/COUNT(J31:W31))