I have a Quantity column and a Unit Of Measure (UOM) column. I just want the
the SUBTOTAL of the Quantity for a particular UOM but not all of them.
Is there a way to do this?
Thanks for the help!

Can any body write a formula to spread the services charge. For example
Annual charge is $12,000/ colum Jan to Dec monhtly 1000/- if start date is
16th Jan then Jan only 16 days and balance to go to colum Jan next year. I
use this formula:

I have a formula calling for an average in a workbook that refers to a cell
group that is sometimes not used.  To keep the cells from averaging, I insert
an X.  That works fine, but when ALL the cells are X I get that irritating
"You are trying to divide something by 0" message.  ...

I want to set up a hyperlink to a named range.  I have to set up about 2000
hyperlinks and I need to have the hyperlink obtain the range name from a cell
in the same worksheet.  For example I will have range names entered into
cells B1:B5.  I want to set up hyperlinks in cells C1 ...

How can I disable excel when copying from exp. Cell C4 and past special
formulas into C5 that copy the same cell number exp C4 and not C5.
p.s. – I am trying to link the same cells from couple of worksheets into 1
column (exp. In column A, I want to link all C4 cells from all ...

Is there a way to dynamicly link worksheets, such that new inserted
lines in the source sheet are also added to the linked sheet?

I need help with the following:
On Sheet 1, I have a list of about 100 employees: A= Last Name, B=First
name, C= (blank).
On sheet 2, I have a list of all employees (40,000+) broken up in 3 columns:

I want to import the text from a cell into the criteria portion of a DSUM
formula (=DSUM(database,"field",criteria)
I am trying to do: =DSUM(DATABASE, "FIELD",=H25)
Cell H25 contains text from a result of a VLOOKUP.

Hi, I would like to enter "equal formulas" that would keep the value and
format of the cells of origins from another worksheet, so that when I change
a value or format in a cell from worksheet 1,  it is automatically corrected
in the worksheet 2. Is it possible? how can I do ...

What is : 5 or 13 characters, or 10 or 26 characters using digits 0 - 9 and
letters A - F? Some say i should use the DEC2HEX formula, but i still don't
know how...

I am trying to use Excel for a grade book, but can not figure out how to get
the average function to not count blank cells as zeros. The following
function is in the Averages column:
=(IF(SUM(I15:AH15),ROUND(SUM(I15:AH15)/$I$10,2),""))

When creating an amortization schedule in Excel from scratch (i.e., not using
the templates) can Excel differintiate between actual/360 amortization and
30/360 amort? If so, how?

I have file run.xls in d:\xls\
in vb i need to open file open.xls in direcory from witch I opened run.xls,
this is d:\xls\
if i move or copy entire d:\xls into e:\xls i would like to open open.xls

I would like to be able to copy a block of cells, and in paste special I need
to be able to transpose and paste link. When I check transpose, I cannot
click paste link.  I know a pivot table will do this.  Is there an easier way?

Is there any way to have pre-formatted controls and form items (drop-down and
check boxes) appear when a certain value is input into a cell?
What I am trying to do is when a person enters a project name into column A,
a drop-down will appear in column B, and check boxes in column ...