I have price tables that are similar to the below
      A       B                      C           D            E             F
1    PLN    RANGE                 1           2            3             4
2    UCP  30000-50000      790       850         950           1500

I'm about to run a fantasy sports league, id like to do it on excel. just
wondering if there was a way of linking everyones team with there players, so
that when i update players individual scores, the team scores are also
updated.  What formulas would i need to use etc.

I want to add a field to my query based on another field. The "another
field" is a date field (field_date).
What I want to do is: IF(field_date >=01/01/00 and <=12/31/00, "2000",
0)

I need a formula that will count number of names on A2:A48 except blank cells.

I have a few cells that contain drop down boxes and a "message" box. The
"message" box appears when you scroll or click in the cell. The "message" box
contains instructions on what do in the cell and was created by another user.
The "message" box is not an inserted comment...I ...

If I have a formula that looks like =D2/$D$4
What do the $ mean? If i remove them, the results stay the same?
Thx

I have a (for me) serious problem. I have just been upgraded from Office
2003 to Office 2007 at work!
For some reason all of my Ctrl + "shortcut key" doesn't work anymore :o(
Evertime I try to use a Ctrl + "shortcut key" function I get a message

I need a formula to give total records of a column except blank cells

I have a column of data that is 3500 cells. I want to get averages of
this data by every 30 cells. Is there any way of doing this besides
than manually calculating the average for every group of 30 cells?
THanks!

I am trying to sum 2 columns together and multiple it by another cell if one
criteria is met.
The formula I am using is not working and displays #value. It is
=SUMPRODUCT(--(A12:A149=A4),C12:C149+H12:H149)*D2

I am facing a problem in Msgbox() function. I dont know if the problem
is caused by a limitation of msgbox or of Excel itself but I cant
figure it out.
Following is the exact (single) line of code I am using.

I want to use something similar to the vlookup function to input a product
code, and a BMP picture automatically is placed into excel and is
automatically sized

I'm creating printed datasheets where each worksheet tab is for an individual
piece of equipment.  The format and size of each worksheet is identical so I
would like to copy the "Page Setup" for each sheet so that I don't have to
perform the page setup for each sheet (about 15 ...

i want to highlite a line in a reply and can't seem to find that option, is
there one?

I have a spreadsheet that does a very simple calculation Column M minus
Coulmn O. Column M and N are merged, Columns O and P are merged, and the
answer is supposed to appear in Column Q (which is merged with R). I have a
workbook that has 3 tabs containing this calculation and it ...