Have a group of cells in a row that all contain similar formulas.
They look like:
=IF(T17="","",T17*($M17/$N17)) or, =IF(U17="","",U17*($M17/$N17))
I want to add up the results of their formulas, including the cells

I've a data gathering and calculation summary sheet in a workbook, the other
sheets provide raw imput data.
The formula =SUM((B5+C5+E5+F5)*(200000/M5)) in N5 displays error #DIV/0!
because M5 has a 0 valve (no problem if M5 is 1 or >). I believe IF will

I have a main worksheet with a list of everyhing, and then 12 more worksheets
with smaller lists.  What I am doing is typing in something on one of the 12
worksheets and using vlookup to find that on the main worksheet and transfer
the numbers that correspond.  Here is an example ...

Is there a way to write a macro that will recognize and print only those cell
that meet certain criteria? In particular, I have a huge spreadsheet that is
used to order material. When a non-zero quantity is placed in a cell in
column C, it would be great if the program would ...

Hi
Is it possible to use VLOOKUP across a 3d range? I have six sheets in a
workbook, and on each sheet column G holds a store number. I have created a
3d range across the sheets.

I'm struggling with designing a spreadsheet. I am cataloging quotes referred
to in various speeches and organizing them by topic.
My columns look like this:
Topic   Quote    Original Reference    LDS Reference

Hi I was wondering if anyone has done Eulier Totient Function on Xcel at all?

How can I create macro when you enter data in sheet1 column it should
automatically update column of sheet2 in the same work book??
Thanks,
Padma.

Using Excel 2003, and having a problems using formulas and then copying those
formulas and using auto fill. This is so frustrating. It would be helpful is
someone could review the worksheet to see what I am doing wrong. I don't know
how to attach the worksheet to this question.

I have a row of user entered data (B-AP7) and a date cell (A7).  I would like
to update A7 with the current date any time one or more cells in B7-AP7
changes.  If there is no change, A7 stays constant.  I would like to repeat
this functionality for the next 99 rows.

I need to set up a cell that counts the number of rows I am using, and sets
that number in a cell. Is there a way to make sure to check to see if the row
has a value in the first cell. I know i need to set up some type of if
statement for this, but I'm not sure how to go about it ...

I am creating a worksheet to measure completion of a project/order.  What
formula/function can I use to figure out the percentage of completion?  I
have formulas for start/end days, but don't know where to go from there....

How do you get a cell ixed to where you can click on it and the current time
automatically comes up and does not continue to follow the time clock after
you have selected the cell and clicked off of it? I am trying to make a
dispatch sheet for when my rescue squad has a call at a ...

This is not the perfect forum for the question below but I am sure the
Excel experts have at least thought of this issue.
I would like to number sub-folders in a directory (each sub-folder
might contain Excel, Word, PDF, or text files or any combination

I think that there is one statistical funtion that does the same of this
formulas report:
Average
Median