Thanks this did the trick
From: ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] On Behalf Of Tom O'Connor Sent: Tuesday, 5 July 2011 8:53 AM To: ozMOSS Subject: Re: calculated column 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 <paul.no...@ceosyd.catholic.edu.au> 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: ozmoss-boun...@ozmoss.com [mailto:ozmoss-boun...@ozmoss.com] 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 Description: Description: email-logo Ground Floor 175 Fullarton Rd Dulwich SA 5065 Tel (08) 8304 8888 Fax (08) 8364 2910 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 ozmoss@ozmoss.com http://prdlxvm0001.codify.net/mailman/listinfo/ozmoss
<<image001.gif>>
<<image002.gif>>
_______________________________________________ ozmoss mailing list ozmoss@ozmoss.com http://prdlxvm0001.codify.net/mailman/listinfo/ozmoss