Can anybody tell me why they think this formula isn't working.  I have
similar formulas in adjacent worksheets that work fine.
=SUMPRODUCT((E25:E5000)*(F25:F5000=9)*(G25:G5000=6.5))
I get the #VALUE! error.

I have a workbook, approximately 5 meg, with  many formulas.  None of
the formulas link to external workbooks.  There is a "Calculate"
notation at the bottom of the worksheets that never disappears,  even
when I hit F9 to recalculate.  Any idea how to get rid of this

This seems simple, however, I'm struggling. We have a master inventory list,
I want to make an order form on a separate sheet that when data is inputed to
the quantity to order columns on the master list it will move description,
quantity and weight columns to the order sheet. I ...

I have the following, how can I concatenat the cells?
Row A has dup but row B does not. I need a formula that will look up row A
and concatenat row B, but if row B was alread concatenated, then concatenat
the next cell. e.g. ABD = AIR EXPORT / Domestic, e.g. ACS = AIR EXPORT /

I've written a function() that validates the interrelationship
between 3 cells. If the data is valid, the function looks up
the date from one of the cells in a table of holidays and
returns the name of the holiday. It's acceptable for all

I have excel files that have been doing just fine either letting me make
changes or giving me the option of opening in read only or not.  Now, just
the last 2 days, some (not all) of my files will not allow me to make changes
without saving as a copy, which gets confusing.  What ...

I have seen some purchase order/contract documents that were created in
Excel.  There is a lot of text.  How is this done?  I am okay doing basic
spreadsheets but I cannot figure out how documents with a lot of text are
created in Excel.  I like the appearance of these documents ...

I have a file where people fill out the date of today. If I use TODAY(),
I would get the wrong dates from the dates filled out previously.
My idea would be that the day of today is filled out when something si
enterd in B1. Obviously the day may not change then next day or days

we have some written text in column, we want to add a macro that will add
some other text to that column, how we can do this ???

I have a spreadsheet that is very large and contains a bunch of macros
and formulas. When I am done, instead of sending the entire worksheet
to a colleague for review I cut and past the only sheet they need to
see into another spreadsheet. When they open it they are prompted to

I am trying to right a formula that will read text. The formula would be if
BW is in the cell then multiply by 100% if BW is not in the text field
multiply by 25%
Does anyone have any suggestions?

How many total worksheets (tabs) can you have in one workbook?  Thanks

good afternoon,
i have most of my macro written (Office 2007,) but am having a small issue
with the following line:
   'Sub Email() - sends a copy of the email to the recipients

I assigned macros to texts boxes on the sheets in an excel workbook, so that
inexperienced computer users can highlight particular rows on one worksheet,
and move them to another.
Here is an example of a macro, moving information from "sheet abc" to "sheet

I have the college basketball pool entered. I want to have it fill in the
winners into the appropriate cell. I have the following, which works:
C33=IF(E3>F3,C3,IF(E3="","",D3))
C34=IF(E5>F5,C5,IF(E5="","",D5))