LinkBack URL
About LinkBacks
Hi: I want to average a column of numbers, but just the ones that do not equal 200. How do I write the formula for that??
Thanks
Hi: I want to average a column of numbers, but just the ones that do not equal 200. How do I write the formula for that??
Thanks
with 2007 version you can use
=AVERAGEIF(A1:A100, "<>200")
Never use Merged Cells in Excel
For all versions: =AVERAGE(IF($A$1:$A$100<>200,$A$1:$A$100))
Confirmed with Ctrl+Shift+Enter as it's an array formula.
Dom
"May the fleas of a thousand camels infest the crotch of the person who screws up your day and may their arms be too short to scratch..."
Use code tags when posting your VBA code: [code] Your code here [/code]
Remember, saying thanks only takes a second or two. Click the little star to give some Rep if you think an answer deserves it.
=averageif(a1:a100,"<>200",a1:a100)
Windows 7 using Office 2007 & 2010
Remember your [ code ] [ /code ] tags, makes reading soooo much easier
Perhapds
=AVERAGEIF(A1:A100,"<>200")
adapt the range to your needs
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks