I would like to sum a range if the value is over a certain amount.
dave  10
dave  20
dave  30

This is weird.  This formula returns a zero in the cell:
=SUMPRODUCT((IF($C$5<>"*",'Trial Balance'!$I$2:$I$65536,RIGHT('Trial
Balance'!$I$2:$I$65536,8))=IF($C$5<>"*",$C$5&"S6364002","S6364002"))*('Trial
Balance'!$J$2:$J$65536=U$6)*('Trial Balance'!$E$2:$E$65536))

When I have more than one excel windows opened I can move/copy worksheets
from one workbook/file to other by right clicking the worksheet and select
"Move or copy" option. But one of my colleague cant do that as the opened
workbooks are not shown when he selects the "move or ...

Basically, I want to enter a model number in say, cell A1 and if the value of
that cell is the same as the model number in any cell A2:A80, I want any of
the corresponding serial numbers which are located in B2:B80 to be returned
as a list in another area such as column C. I'm ...

I am trying to use a sumif with multiple criteria so that it will sum with a
range of data included in the criteria. The criteria will be 50+ cells in a
row.
=SUMIF($B$3:$B$6,B10:D10,$C$3:$C$6)

I am not sure if excel can even do this but I have exhausted myself looking
so far.  If anyone could help I would appreciate this!
I am trying to enter the number 1 in row 3 Column C and when I press enter
it will move that number 1 to row 5 column K, while deleting the number I

I have a worksheet that has a set of values (numbers) in row G.  I would like
to add those values but only if the values (which are letters) in row B match
letters that are in columns c through f.  I will attempt to place an example
below this.

If you take a look at my example below...  We'll say I'm selling widgets.  I
need my crew to average 4500 widgets in my two week period.  I can use
conditional formatting to make the number in the "Avg" column green if they
sell good, red if they sell bad (or whichever text ...

I need to go month to month with a value at the beginning of the month, a
cash flow at some point the middle of the month, and a value at the end of
the month. I'm trying to get the ROR for that month.
For example:

=IF(ISBLANK(A1),IF(ISBLANK(B1),"",C1(likely wron formula);
Don't know if I use a comma or OR, or another formula, but if either
A1 or B1 is blank, I want "no value" in C1.  If both A1 and B1 have
value then it returns the Value in C1.

for Excel XP SP3 on WIN XP SP1
What I'd like to have is:
values above 10% => +NN% in blue
values between 5% and 10 % => + N% in brown

Can someone help write a formula that will provide a count total for a range
of cells where the value (xx/xx/xx) is within plus or minus 5 business days
of a date in the corresponding cell of another column.

The formula I wish to use for conditional formatting is
=AND((MOD(COLUMN(),4)=1),(INDIRECT(ADDRESS(ROW(),COLUMN()))=MIN($E17,$I17,$M17,$Q17,$U17)))
If I use:
=INDIRECT(ADDRESS(ROW(),COLUMN()))=MIN($E17,$I17,$M17,$Q17,$U17)

=IF(B3=0,(C3),(B3) and IF(B3=C3, (" "),(B3&" "&C3))). I wouldn't know what am
doing wrong. Please help. Thanks.
if column b3=0, then pick column c3 else pick b3, but if column b3 and c3
are same pick nothing else combine b3 and c3.

I've got a worksheet, c 200 rows, with data in Cols A to L (range name
"Data") where Column L (range name "Result") has a series of variable
numeric values.
I want to create a new worksheet that reports just those rows that satisfy a