software

BUMP!!!

Sorry folks but I could do with some help regarding this, as it appears
to have reared its head again!!!

Any and all help appreciated.

Regards,

Pat.--
pobrien31
------------------------------------------------------------------------
pobrien31's Profile: www.excelforum.com/member.php...foamp;userid=5798
View this thread: www.excelforum.com/showthread...hreadid=361153
An inelegant solution would be if the total on each sheet is held in
cell b12
create a formula in each sheet (say cell c12) if(b12gt;0,1,0). this can
be entered in each sheet by selecting all the tabs at the same time and
typing it in. If the value is greater than zero it creates a 1 the total
of the 1s can be your denominator in the formula.

Your average can then become
=sum(sheet1:sheet17!b12)/sum(sheet1:sheet17!c12)

Obviously if your sheet tabs are named differently you can reference
them as in your average formula--
Dav
------------------------------------------------------------------------
Dav's Profile: www.excelforum.com/member.php...oamp;userid=27107
View this thread: www.excelforum.com/showthread...hreadid=361153