I am trying to sort the number of books i have in my inventory per language
values for such are eg(english=E) in a multiple cell range how do i write the
formula

I have a work book with over 120 worksheets. Is there any way to set the
worksheet protection on all worksheets so that a user can only select
unlocked cells. I know I can do this by selecting each worksheet, one at a
time, and deselecting all options but  "select unlocked cells" ...

I have successfully used SUMPRODUCT thanks to this discussion group but am
having a problem trying to capture a date range.  Is it possibly the way I’m
entering the date?  HELP!  I woke up last night dreaming about this…
Date of Referral  Homeless/At-Risk   Received MV Services?       

if price is higher than 30 dollars markup by 20% if less than 30$ markup by 40%

Hi again!
Bob kindly gave me a suggestion for using VBA to show /hide using a single
button.  This worked fine until I decided I wanted to have another custom
area off to the side.

I need to enter 17 digit account codes into a spreadsheet. the format I set
up to do this was including the hyphens that spearate various factors within
the account codes. However, when I enter the numbers, the last digit is
rounding down and I need it to stay the way I enter it. ...

We're trying to get the option, but no matter what we do when we make
new checkbox, the option is never avaliable. Is there any possibly wa
that we can get that?
I really don't know what to do, please, someone help me out!

I imported some data from a CSV into a worksheet. On another worksheet
(named Chapel)
I referenced the data in a formula:
{=SUM(IF(Chapel!$A$1:Chapel!$A$1000=Categories!$A1,

I'm trying to insert check boxes on the excel spreadsheet. We have th
entire page laid out, and now we're trying to insert the check boxes
but there is one option unavaliable. When I click format and go t
properties, Move and size with cells is not avaliable, is there anywa

I need to copy a section of one sheet to another.
The section contains formulas referring to the same sheet.
When pasted into the second, the formulas should refer to the same cells
on the first sheet.

Where do I download the pack that allows me to use arcsin?

I have a couple thousand rows of data grouped into eight transaction types.
Column A is the type and Column B is the amount. I would like average the
amounts of each of the groups. Can you give me an idea how best to approach
this task? It is repetitive in that this report is ...

I have come across a somewhat frustrating problem in Excel 2002 when using if
statements and then an evaluation which uses indirect addressing and match
statements to perform an evaluation (subject to some preconditions in the if
statement). My evaluation statement

Hi hope you can help.
I know next to nothing about VBA and have adapted code below from stuff I
had.
I simply want to show hide portions of my page to cut down on screen

Please could someone explain to me the difference between using the paste
link function & the “= cell ref” function to link cells between workbooks. (I
find link paste useful as I can link large numbers of cells at one time where
as I have to use the “=” method for each cell. ...