I need a formula that would work as a minimum ifs function similar to the
sumifs formula. Given the data set below I need the minimum list price for
the group in cell A1 but only only if the Use = Y and Finish = Red. Can
anyone help?

Hello,
I wonder if it is possible to make a sheet work in tally chart form?
I have satisfaction questionnaires that come to me periodically. I want to
know if it is possible that excel can, rather than use '1' as the answer, add

I would like to swap the data in an Excel spreadsheet by changing the
columns to rows, and the rows to columns,  For example:
This:   1   2   3                   Would become this:    1   4   7
4   5   6                                                 2  

I am working with deveral worksheets.  I have a excel spreadsheet on one tab
and would like to be able to pull data from a source data sheet on another
tab when I click in the cell.  The cell contains a number which can be
referenced to the source data, however I need to pull in ...

I want to identify a unique part number for a light unit given that there are
three variables associated with it. The variables are voltage, color, and
steady/flashing.
Each voltage has bulbs of different colors; each voltage and color has

I'm so new to excel that even though I know how to create some functions, I
do not know the terminology, so I don't even know what to ask to get my
answer.  Bear with me.
Imagine a table: Down the leftmost column is "Apples" "Pears" "Oranges", and

I'm trying to link from 26 separate but identically formatted files to pull
in similar data.  I want to use a single formula, but swap out the filename
based on the value I put into another cell.  Anyone ever done that?  I keep
trying but can't get past the formula error checker. ...

A1 = 1 A
B1 = 1.5 S
       3 A
A2 = 4.25 S

I know the date that a vehicle needs to go in for it's yearly maintenance and
i want to see if i can cause the cell that the date is in to change color a
month prior to the date....does anyone know if that can be done and how to do
that?

I seem to have lost my sum total ability on my worksheets that usually
appears at the bottom right of the screen when you highlight a few cells to
see what they add up to.  
Any help would be greatly appreciated  :)

Example:
I have a drop-down in A1 with 5 options (A, B,C,D,E)
I need to be able to have a formula that looks at A1, and if it's value is
"A" (from the drop-down) then place a "1" into cell B1.

I would like to compare one cell (A1) to the first 10 characters in a range
of cells (B1:B125). If there is a match, I would like it displayed in C1.
Any help would be appreciated.

I have entered the following in cell A1 ="Average "&AVERAGE(D:D)
and the value I get is Average 47.247619047619.
How can I round down to 1 decimal place?
I have tried number format but it does not make a difference

I got this forumla:
=SUM(IF(('[Title and Reg Chat Data.xls]FY08'!$C$2:$C$9000=W$66)*('[Title and
Reg Chat Data.xls]FY08'!$E$2:$E$9000=$C67),'[Title and Reg Chat
Data.xls]FY08'!$A$2:$A$9000,0))

I am currently searching for a method to do a similar formula in excel.
I currently process around 120 students every 2 weeks into classroom databases. Currently when we recieve the spreadsheet, the names of students show as:
last, first middle initial in cells A1-A120.
I was ...