hi, I am trying to modify the formula below to use the LEFT function.
any help Appreciated..
=SUM(COUNTIF(INDIRECT("DAY"&ROW(INDIRECT("1:31"))&"!H6:H35"),"=W"))
I tried this below, but I get a reference error:

I'm working on creating a grade book, but I've encountered a problem
with excluding an assignment for individual students when averaging the
grades.
I have several different worksheets for different subjects. On each

Haven't been able to find any reference but hope you guys can assist:
Is there a way to make a cell "blink" or "flash"?
Eg - if a particular test is true then the answer cell should blink "TRUE".
XP Home SP2 - Office 2003 - both fully patched.

How can I calculate an average automatically dropping the lowest value--I am
requested to use SUM, MIN and Count functions.
Thanks

If employee number 5263 found in sheet 2, show the raw in main data on sheet
1 in red, for instance.

I'm  all employee data in sheet 1,  in sheet 2 I'm using vlookup function to
retrieve employees for whom I issued certificates on a each day. My question
is, how I can mark those employees in sheet 1 for whom Ive already issued
certificates from those for whom I didn't. I tried ...

Do you guys have a site similar to the site the word folks have below for
creating and manipulating pivot tables?  We would like to learn how to
create pivot tables in excel 2000, we will soon be getting Office 2003 but
will be keeping 2000 also.  We also have some money in the ...

I have found many third party applications for creating Pareto charts in
Excel, but does anyone have a simple and effective method for creating them
in the native version of Excel 2003? I'm specifically looking for the
left-to-right sorted histogram (bar chart) with a line graph ...

i want to make a formula for the same cell which i want to enter data in it

I want the formattin of a series of cells to be dependent on the data in
another cell. For instance, if A1 is a result of "something" then A1:A7
will all turn red. How do I get that done??

I have a column in Excel where I pasted user names from SharePoint.
Unfortunately the values now have a URL association with it.
Is there any way to remove the URL from the entire column without having to
do it line by line?

i want to get the resaults of a "find" search all together  in a new
window,so i dont have to keep using "find again"

I want the formattin of a series of cells to be dependent on the data i
another cell. For instance, if A1 is a result of "something" then A1:A
will all turn red. How do I get that done?
--

I am working with a large data set. (It is currently a form in Microsoft
Word)  I need to import data into Excel (2003) but am getting an error
message which does not allow me to import all of the data since I have
exceeded the range of columns available in my spreadsheet.  I ...

i would like to do a loop on criteria list in order to use it for a
comperasion for access file,
what is the best way to do it?