I have a spreadsheet with the following:
Column A Has codes 000 down to 999.  This range includes letters such
as 68A.  Each of these codes have values in column B.
I am looking for a formula to calculate the total values in column B

I have a two sheet workbook, the first page being where all data is kept the second being the totals needed.  I have a countif function tracking the date of a request made, and it is working great.  The problem is that there is now five people taking the requests and I need to ...

I have this formula " ='098'!$D$6 "
I need to change the sheet 098 to sheet 099 then to sheet
0100 and so on.  Does anyone know if this is possible and
if so, please send the command line or script.

Is it possible to use conditional formatting on a whole
row, based on a condition in one of its cells?  If the
content of cell H3 is 'Temp' I want to shade the whole of
row 3 light grey, not just the cell with that word in it.

Hi Guys (and Gals):
   I have the function AVERAGE(A1,C1,E1,G1) working fine; except that it
produces the message "DIV/0!" when there are no entries in A1, C1, E1, and
G1.  Some time ago I noticed a tip on how to eliminate this "DIV/0!" message

I have a spreadsheet named XYZ [Group] and find that I cannot sort, filter, etc. in the spreadsheet.  Is the reason why I can't use any of the functions because of the type of spreadsheet indicated by [Group]?  How can I change this spreadsheet to allow normal functions to be ...

How do I count entries in a column that duplicate?  I want
to count repeating #s in a column as a single entry.  
Thanks

Can some please help? I can't seem to get this function to
work! I keep getting the error message "Failed to get
requested data" or "Failed to download settings from the
Internet"... I have tried re-installing, double-checked

Well what im try to do is modify an exixting spreadsheet, currently the
formula looks at a cell value in column AX then the match formula looks
in the file yarncost in column B for the value from column AX and
returns 0 if it does. The problem is that the spreadsheet yarncost has

I think this would be possible, but I'm stumbling in trying to figur
out how to manage it.
Here's what I have...I want to take sheet X and have the formula i
column F.  I want it to look at the corresponding cell in column

Imagine that the data I want to read and join in column is in a column but
in alternated rows. I mean:
A1 = 'Data1'
A5 = 'Data2'

Hi,
Still have been trying to get that function to work out
for me. Went to programming recommended can be done
through functions, not sure how still, but this SUMIF

Got a quick question, I went to save a spreadsheet and for some reaso
it added a :1 at the end of the spreadsheet name.  No matter what I d
I cannot get it off.......what gives?
Thanks,

Does anyone know how to "automatically" update a sheet
reference without changing the cell reference?
I have summary page which links to the same cell on each
page.

Here's my issue:
I'm trying to decide if I should pay off a college pre-paid tuition program, or stick with the payments. Here are the figures:
$13,080.61 = Payoff amount
$166 = monthly payments for 10 years = $19,920 (166*120)