I am setting up a spreadsheet to calculate some figures for me and woul
like to set up the last column to display the results.  Several of m
column are added together and the results then divided by a value (no
yet entered in the spreadsheet) resulting in the #Div/0! error.  How d

I want to create two or more functions to works in one cell, respectively:
IF(AND(B5=B21,A5=A22),SUM(C5),"") and  IF(AND(B5=B21,A6=A22),SUM(C6),"")
Independently they work but when I’m ordering one by one in sell appears
FEALS.

It appears that I cannot add up more than 30 cells at a time.
Is this true and/or is there a way round it?

I have this formula that produces an error in a column:
=IF(OR((ROUND(N3,2)=ROUND(H3,2)), TRIM(H3)="$-"),"OK","ERROR!")
Columns H and N are both currency. If they're equal it's supposed to
display ok. If there is no value in H it's also supposed to show ok,

how can i draw an 11x13 room? I want to put the design in word or excel and
put places where my furniture can be to try to design my room as best as
possible. Can this be done in Office or will another program do better?

I need to  figure out how to automatically assign dynamic range names to
each "Saturday to Friday" in a list of monthly day numbers and associated
day names for an entire year.
A     B

Hey i am currently using the following code,
and I would like to sum the values which are in the second column, i am
currently evaluating the first column,
==>

How to return the Autofilter value into a specified cell

I have something I can't figure out how to do because of the dynamic aspect
of the pivot table.  I've put a sample document at
http://veritasinsurance.com/sample.xls
If you look at the tab "Pivot Table" and read the OBJECTIVE you'll see what

Is it possible to shade every other row on an existing spreadsheet without
manually shading? This would make it easier to read a list across the row.
Thanks,
Bob M

Is there a way to copy and paste columns that are not adjacent i.e. the
are on the same rows but there are columns in between that I do not wan
to copy (and do not want to move adjacent) - they are to go into autoca
as an embedded file.  What if the columns are not on the same rows, ...

how to occult a all sheet only?
its possible?
thanks
Marina

Can someone tell me how to cut out a part of a text?
Example:
  A
1 Portfolio and Data at end: June 2004

I'm not sure how to explain this.  Say I have different numbers in cel
A1 to cell A10 and I want to add the same number, 133.025, that is i
cell D1, to all of the other cells.  How can I do this without havin
to do it the long way

If you can provide me the list of Unique Entries only