Tom's Guide | Tom's Hardware | Tom's Games

Computing.Net > Forums > Office Software > Excel 2007 Filters

Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to get for your free account now!

Excel 2007 Filters

Reply to Message Icon

Name: keepcback
Date: January 11, 2009 at 19:57:33 Pacific
OS: Windows Vista
CPU/Ram: Centrino/3 GB Ram
Manufacturer/Model: Hewlett-packard / Pavilion dv2000
Subcategory: Microsoft Office
Comment:

I have three columns of data. 2 consisting of zeros and ones and the third of data. At the bottom of one of the numerical columns I have sum and average of sum and the second column I have countif and average of countif. When I filter the data column the number of zeroes and ones reduces in the other two columns. I loose the rows containing the sum and countif information and I am left with only the averages, and at that, the average does not change! What am I doing wrong? HELP!!!!


Report Offensive Message For Removal
Reply to Message Icon

Related Posts

See More



Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.


Go to Office Software Forum Home


Sponsored links
Ads by Google


Results for: Excel 2007 Filters
Excel 2007 won't immediately open www.computing.net/answers/office/excel-2007-wont-immediately-open/6854.html

Excel 2007 will not auto refresh www.computing.net/answers/office/excel-2007-will-not-auto-refresh/6862.html

Is Text-to-Speech in Excel 2007 www.computing.net/answers/office/is-texttospeech-in-excel-2007/7407.html