Is there a way to calculate the average of a list of numbers only if another
field in the same row contains a specific character?  I have a spreadsheet
that contains lines of data with dollar values in one field and either an "M"
or an "R" in another field.  I want to calculate ...

I am working on a Free Give Away of some products.  Our systems give me a
list of individuals who we have had contact which are then placed in excel.  
We would like to pick a weekly winner and would prefer not to throw darts at
my screen.  Any Ideas?

Hi: I have a worksheet with these columns:
D = first name
E= last name
F = sandwich order

I am not getting any result with this formula.  I have tried it two different
times.
When I use this:
=IF(D38=1.09,"$1.09",0),IF(D38=4.49,"$1.09",0)

Rows of data from two sources have been combined and sorted on one worksheet.
To identify the source of the data, the rows are 'flagged' with the acromyns
"ign" or "leg".  The only reason they are appearing on this report is that
there is/are cell(s) of data that have been ...

If I have a column of dates (column A) which are in order but not sequential
and a corresponding column of values(column B), how can I calculate an
average for the values dating back one year from the last cell.
Column A          Column B           Column C

How would one set a field to 0 when the field is blank without overwriting
any current values in the range?  Thank you in advance, and Happy Friday.
Mary

Apologies if this covered - cannot find.
I believe that the row_index_num in HLOOKUP will never adjust as the formula
is copied down but users in our Finance dept are all insisting they have been
using HLOOKUP for years and the row index has always adjusted as the formula

OK,
I have a spreadsheet that contains a tab that I copy into other spreadsheets
on a rather regular basis.  It has to do with legacy data.  Anyway, I copy it
in, do a find and replace to get links to the original spreadheet to point

I am trying to creat a number from different cells. I have 4 cells that are
in the following order:
B13 - 1.9
B14 - 40

I have an Excel working document where I store all of my vital data, such as
logon name, passwords, credit card and bank account numbers, etc, etc.
Unfortunaly I have ran into a problem that I cannot solve.
My personal Visa credit card number (last digit) ends in the numeric number ...

HELP!!!
I've got 8 nested IF(AND) staements in my formula, please help! Is there a
simpler way of doing this???
I need to return the percentage margin for the lowest selling price. Y, AQ,

Hello to All:
I am trying to take 36 Workbooks with the same categories of data and
combine into 1 Workbook without copying/pasting each workbook.  I evidently
am doing something wrong using the Data - Consolidate function.  Any help

I'm trying to use the OR function in a CF formula without success.  The
formula I'm using is:
=OR((LEFT(E87,2)="M-"),(VLOOKUP(E87,$Q$2:$Q$10,1,FALSE)>=1))
For some reason, the VLOOKUP is working, but the LEFT doesn't work.  I

I want to create a formula with variable sheet names based on the contents of
a cell.
A1 = Sheet1
A2 = Sheet2