I am trying to add a column that has #NA as a result of using the Vlookup
function. I would like to add up the column that does not have #NA as an
answer.

I have a list as follows:
CE0114XXXX42___
CE0114XXXX42___
CE0114XXXX42___

I was wondering if there is a formula that would count how many times
two names in two different columns match?
For example:
Column A      Column B              Formula Result

I was wondering if there is a formula that will allow me to count how
many times a name is found in two seperate columns?
For example:
A                       B                 Formula Result

The number format is 0.00.   The font format is arial /bold /dark red.
The cell contains a rather complex formula (for me)
=IF(O21="FLEX",V21,IF(O21="HOLIDAY",V21,IF(O21="flexpart",0,AL6)))
I have been to tools/options/view and "unclicked" zero values.   Still shows

I have an excel file (example.xls) that when I open it, opens two copies at
the same time, named
example.xls:1  &  example.xls:2
If I close example.xls:2, it removes the ':1' from the other file name.

I'm new at this so I'm not sure of the validity of my question. I'm
trying to import data from a standardized format.  The problem is that
the number of rows will vary depending on the set of data.  So I need
some code that will take a selection starting from "Operating

I have two worksheets and I can pull the ColB column of data over to where I
want it with vlookup but how can I then get columns C thru G over to my
worksheet?  I am trying to pull forecasted prices for the same row of
information.  Here is my current function formula:  ...

I'm wondering if there's a way to automatically create a worksheet based on a
new day. I have a workbook with a worksheet for each day that I'm on a job
for my work. I have to copy the last day's worksheet and rename it to the
next day, for example, "Day 1" becomes "Day 2". What ...

I want to add a leading dot to a cell so that it leads a bunch of dots to the
next cell.  For example (hoping and assuming this will display correctly on
this post):
Cost for cleanup 8/28/2007.................................. $250.00

I'm having an annoying problem where the Horizontal Navigation-Scroll Bar at
the bottom of the Excel screen, just to the right of the worksheet tabs,
partially disappears and stops working (intermittently)???
Any idea's or similar instances occurring out there?

Hi,
I have a number of rows of data which I need to get into a text file.
However, what I need is each cell of informaton within these rows to be on
the text file one under the other under the other etc.

I copied/pasted some text from the internet and now have a checkbox in my
spreadsheet that won't go away. A previous post says to right-click to bring
up a menu, but right-clicking has no effect. Help!
Many thanks.

When I try to copy text that has been wrapped in a word table it pops it into
excel on three lines instead of the cell.
Can anyone help me out on this?

I am trying to sum column if column I meets two criteriam I have tried sumif
and sumproduct with no results.
Columns A is Staff Names
Columns B thru G are week days