This one requires the Excel guru's or any one with an answer!
What I need to do is the following. I have part of it working already, but,
still miss additional information.
I have an application which contains data for employees names on a sheet

If i give a formula to add two numbers in cells a1 and a2 of sheet1 and the
answer for this formula should be displayed in b9 of sheet2 how can i do
this?.Please answer for this question and send me to anuraga1@hotmail.com

Using Excel 2007 Beta 2.
I have two cell ranges (B2:G2 and N1:N13), each of which contains a list of
non-repeating integer values in ascending order. I want a formula that
computes the number of values in the first range that appear in the second

When using VLOOKUP to find an exact match for a value, and if there is no
exact match, the formula will return "#N/A".  How should I modify the formula
to make it return the number 0 instead?
Thanks

I am unable to highlight the cell range on the document I am seeking data....
If I try to highlight A1:G733, I can not start the highlight in cell A1.  I
CAN however highlight my range if I start at cell G733.
anu explantion?

I have 100 squares. what are the odds if I buy 1 ticket. what are the odds if
I buy 4 tickets.
How do I get excel to do this?

When I open a XLS file, how can I know if this file is using some custom
addin (eg. MyAddin.xla)?
Rodrigo Ferreira

I made a Addin (excel) and installed on my computer on folder
C:\Documents and Settings\MyUser\...
and I installed this addin in a lot of computers.
But when I open a file (in other computer) that uses a function from my

I have a Pivot Table in Sheet 1 named "pvtMain". In the other sheets
within the spreadsheet I have several pivot tables which link to
"pvtMain". Thus all I need to do is refresh the data in "pvtMain" and
all of the other pivots refresh automatically. The problem I'm having

Advanced filter formula for "contains="Sept"

I have the following data:
Logins    Trimmed agent
933,858    Mozilla/4.0(compatibleMSIE6.0WindowsNT5.1)
66,788    Mozilla/4.0(compatibleMSIE6.0WindowsNT5.0)

Where can I find information about the use of "__" in a formula?

I have a 'Sumproduct' function working fine on my Excel file, but I need to
use similar method, this time to do the average instead of sum. I need to
evaluate about 4 criteria, then average the numbers from another column. I
know there's no such: AverageProduct function. I have ...

Is there a formula you can use to replace blanks in a worksheet with zeros
without manually going thru the rows and columns and clicking in the zeros?

How Do I Input A Formula For Averaging?