You should be able to do: =(col1+col2+col3+col4)/(IF(col1>0,1)+IF(col2>0,1)+IF(col3>0,1)+IF(col4>0,1))
This should exclude nulls and 0's. Cheers, Tom On 5 July 2011 08:26, Paul Noone <[email protected]> wrote: > The real average would include the zeros.**** > > ** ** > > Otherwise you could try something like:**** > > ** ** > > =IF(AVERAGE(Column1), Column1>0)**** > > ** ** > > Regards, > > Paul**** > > ** ** > > --**** > > Online Developer/SharePoint Administrator, > ICT Infrastructure Team > *CEO Sydney***** > > ** ** > > *From:* [email protected] [mailto:[email protected]] *On > Behalf Of *Chris Grist > *Sent:* Monday, 4 July 2011 4:05 PM > *To:* ozMOSS > *Subject:* calculated column**** > > ** ** > > Hi Guys,**** > > ** ** > > I am doing an average on a set of columns. SharePoint includes the value > 0.00, but not if the column is blank.**** > > ** ** > > Is there an easy way to exclude the columns from the average if the value = > 0.**** > > ** ** > > Would some kind of IF statements inside the AVERAGE statement work?**** > > ** ** > > Otherwise ill need to come up with a way to clean up the 0’s.**** > > ** ** > > Regards,**** > > *Chris Grist > *MCITP, MCTS, VCP > > Senior Technical Consultant** > > [image: Description: Description: email-logo] > > Ground Floor > 175 Fullarton Rd > Dulwich SA 5065 > > Tel (08) 8304 8888 > Fax (08) 8364 2910 > [image: Description: Description: partnerbar-email]**** > > NOTE: This email and any files transmitted with it are confidential and may > contain information intended only for the addressee(s). If you have received > this communication in error, you must not copy or distribute any part of it > or otherwise disclose its contents to anyone - please notify Loftus IT > immediately. Loftus IT does not accept liability for any errors or omissions > in the information provided herein. No representation is made that email and > any files transmitted with it are virus-free - virus scanning is the > responsibility of the recipient and is recommended.**** > > ** ** > > _______________________________________________ > ozmoss mailing list > [email protected] > http://prdlxvm0001.codify.net/mailman/listinfo/ozmoss > >
<<image002.gif>>
<<image001.gif>>
_______________________________________________ ozmoss mailing list [email protected] http://prdlxvm0001.codify.net/mailman/listinfo/ozmoss
