How can I change the default settings in the field settings? I want it to SUM
instead of COUNT. I am having to change multiple fields one at a time.
Thanks.

How do you set it up in Excel to have predictive typing in your drop down
list? For example so if I type ka....anything in the drop down list starting
with Ka appears.

I have a spreadsheet with 300 rows and colums up to IR.
The columns repeat- #, description, size. I need to convert the spreadsheet
sp that it is 3 colums wide only with the title above and have all of the
information drop down into these.

I have a list of data containing names (30,000+) that I need to look through.
Can Excel tell me which rows a name appears using a formula using something
like CELL(not using find or filter)? I need to leave them in their mixed-up
order.  My boss wants the exact row numbers of ...

I am trying to use the VLOOKUP fcn in my spreadsheet and am getting the REF#
error in the Table Array.  I checked my named ranged, and they appear to be
okay.  Any other suggestions of what may be wrong?  

Does this make sense?
Situation:  Receive database in client format.  I insert a key column,
number it sequentially so that I can put it back in order after manipulating
the data.  I then add a formula on each row, example:

I have used the same Excel 2003 workbook for many years, and all of a sudden
the formulas just stopped working.  I can re-enter the formula, but it will
not calculate?

I have two tabs with a large amount of data in each.
They are called "5-8 ICAS" and "5-15 ICAS".
The header row on both sheets are exactly the same.
Due to fear of macros here at work, I won't be able to use one for

Hi, how knows the name of the match function in Brazilian portuguese?
regards

On a Timesheet I would like to add the total time for weekend days seperately
from the weekdays. So I would like to add all weekdays, not Sunday and
Saturdays, and Saturday and Sunday together.Thanks, Mon

I've got a list of 16 digit numbers and I want to remove the last tw
digits from each one.
I am totally stuck as to how I can do this.  Can't use find and replac
as the numbers are totally random.

I am wondering how to add to a previously summed number.  For example, I had
+ .4420+.0080+.0020-.0025 + .0075 - .0040 in a cell with a closing value of .
4530.  Next week I would like to be able to add my change, let us use as
example +.0085 to the summed figure, not having to add  ...

I am trying to complete transcripts with the GPA.  Next to each rows, I have
figured the IF formula of the students grades, (quality).  I now need to add
the sum of the quality and divide by the total credits earned.  How do I find
the SUM of IF.  I tried the SUMIF formula, and ...

I want to use a cell containing a sheetname to dictate the color of the
cell next to it.
For info on how to use cell input to reference a worksheet See:
http://groups.google.com/group/microsoft.public.excel.worksheet ...

How do I use Excel to average students grades given in letters?