In Excel 2007, I have entries of the form: 500A+12.  I Would like to get rid
of the A and sum the numbers (i.e. return 512).  I can return 500 and 12
using the left, right, and len functions, but I'm assuming they are being
returned as text because when I sum them I get zero.  Is ...

I receive a spreadsheet from someone outside of my company's network.  I take
this spreadsheet and add columns to either side for my company's data.  
Example:
Original spreadsheet ("OS")

In Sheet1 I have a database and I have created a template with formulas
which pull up information from that database, now I want to keep the database
in Sheet1 and move the template to Sheet2 but I want to link the values in
Sheet1 to the formulas that I have in Sheet2.

I am trying to link two worksheets in the same workbook. I have a column of
values in Sheet 1 that will change over time. I would like to link whatever
number I type in to the same value on Sheet 2. Sheet 2's values constantly
remain the same. How do I set up a link that will ...

I'd like to sum if two conditions are met. Here's what I've tried, but didn't
work.
=SUM(IF(E1275:E1299,A16,AN1275:AN1299)*(G1275:G1299,A14,AN1275:AN1299))
I also tried

I hope someone can help me
I have just started with a reasonably large homeless organisation where they
collect large amounts of statistical data using excell. There are 25
induvidual services hence 25 induvidual data sets. Each set essentially

I have tried unhiding rows and my worksheet is not protected and the panes
are not frozen.  I have also tried selecting the entire worksheet to unhide,
but I wasn't able to see all of my hidden rows.

I have a workbook where on the tab "Data"
tab "Data" Column A, Cells A2:A2500 Gives a Year Value (for example, 2007,
2008)
tab "Data" Column D, Cells D2:D2500 Gives a specific Date (for example Feb

We purchased the Compare Spreadsheet Add-in for Excel to save some of our
end-users time (which it does), but now they can't figure out how to print
them.  Apparently there is not an option to print.  Does anyone know of a way
to print these, or is this add-in just for viewing ...

Does anyone know what software I can use to scan receipts and have them go
into an expense account form for submission?

I am trying to hide only a few rows in my document. Imagine my suprise when
the entire sheet disappears...I can't do anything at that point except close
the program. It doesn't allow me to undo or anything.
Anyone have any ideas?

I have filtered a table of numbers and when running advanced filter for items
"containing" the digits 1683, no rows appear. I know that there are scores of
entries containing this string. All cells are formatted as numbers. Any help,
please?

I have created a mail log at work on Exel, but the trouble I'm is each I make
a new entry I to continue to add a item number in colume A (1, 2, 3.....). If
anyone can answer this question I would greatly appreciative.

I have created a drop down list on sheet 1 from named lists on sheet 2, does
anyone know how to make the drop down arrows stay visible as opposed to only
showing when the cell is clicked on?
Your help is greatly appreciated.

before i have used the {sum(if(a=b)*(c=d),a:z,false)}
I know the formula says if a=b AND c=d then sum a:z
Is it possible to do a=b OR c=d then sum a:z?