Divide by all values greater than a string of 0 length

[clintonmadden]

..or something like that..

Basically I have this formula:
=IF('Delivery Suite'!K17+'Orchard Mat.'!K12+'Orchard Gynae'!K14+Riverbank!K10+Meadowbank!K13=0,"",'Delivery Suite'!K17+'Orchard Mat.'!K12+'Orchard Gynae'!K14+Riverbank!K10+Meadowbank!K13)

So it's calculating the sum of the cells if there's something in any of them I think. What I need is to then divide the result by the number of tabs/cells that have any data in them, so this could be anything between 1-5 depending on what data has been entered.

If anyone can give me any help on this, or handy pointers it'd be appreciated!

Thanks

Clinton

 

[chergh]

The count function should do it

=IF('Delivery Suite'!K17+'Orchard Mat.'!K12+'Orchard Gynae'!K14+Riverbank!K10+Meadowbank!K13=0,"",('Delivery Suite'!K17+'Orchard Mat.'!K12+'Orchard Gynae'!K14+Riverbank!K10+Meadowbank!K13)/COUNT('Delivery Suite'!K17,'Orchard Mat.'!K12,'Orchard Gynae'!K14,Riverbank!K10,Meadowbank!K13))

 

[clintonmadden]

Thanks for the reply, I'll give it a go!

 

[clintonmadden]

It's working perfectly! Thanks very much for your help.


Clinton