Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
excel Q.
Name: sue Date: June 2, 2003 at 23:15:26 Pacific OS: windows 2000 CPU/Ram: p4/512
Comment:
hi there,
i have used this to cal the average (=SUM(C5:AG5)/COUNT(C5:AG5))
However, some of the columns from c5: ag5 has no data in it...and DISPLAY " #DIV/0!" Does anyone know how to get rid of this display even no data is available in the column
Summary: I am trying to create an Excel template that references two different workbooks. A new workbook must be created every week and must refer to the previous workbook to pull in data. Rather than each ...
Summary: When I select a list value on an Excel form combobox that I created I want to go to another worksheet. For example, list box values are country names. For each country I have a worksheet with info on ...
Summary: I am trying to do a summation of data in a column that has 3 conditions. First I need to sum the heights in column O that is blue, red, or green (column q), and are greater than 10, less than 30. (col...
