I frequently have to use .xls or .csv files to import data into another
system, however the system requires that all fields be text (except
where a number is a genuine number).
My problem is that I have two colums of numbers that have to be

I want to count the number of "passes" from a column based on the
criteria that the adjacent column cells contain the letters "AB" at the
start of what ever is in the cell.
i.e.

Seemingly simple but actually difficult?
I want a sumif formula that sums the target range if any of the cells
matched are not blank, if all of the cells matched are blank then it
should return a blank (and not a 0). If the sum range does have any

I have two columns, one of which row by row, may have blank cells in and
other may have data.
I need to create a function in C1 to say IF A1 is NULL AND B1 is NOT NULL,
then return a character.

Here is my problem
I want to sum the values in a column if they meet two criteria, see below:
A                     B                  C                       D
Site            Vehicle               Value                  4 Wheeler Bardon

Here is what I need to accomplish:
In cell A1, I want a formula to read another cell, say E5.
Cell E5 is a drop down list with only two choices
If it is choice one, then I want cell A1 to display a "T"

Is there a formula to count the number of items in a list and its
corresponding sum value, eg
Item           $
apple         1.00

Dear Experts, below is the excel worksheet and i have problem locatin
the numbers because the numbers are not in the standard column, some i
B, some in C and D and the length of the numbers are not standard too
some 2, some 3 & 4 digits. If i want to send the numbers to specifi

I am trying to use sumproduct to get an average of a column, based on a
criteria in another column.
In one data sheet, i have:
Name         AHT        Quality      Resolution

Hello from Steved
With the below macro how could I shift the cursor down 2 cells please.
Sub Broken()
Selection.EntireRow.Insert

This should be really easy, I am just terrible with excel.
I want to set up a personal finance database. It is a very easy worksheet
that just looks like this
        A                 B                C

Help with a forecast function.
I am trying to figure out how to calculate the number value to increase my
percentage from whatever it is currently to 95%.  I have 3 pieces of data,
good records, nuetral records, and bad records.  In cell 1a I have the % of

2 questions please.
I have got a spreadsheet to calculate time in hours and minutes
A                    B                    C
15:00              20:15             5:15

Can I make a group of cells in Column A, "float" or stay near the top left of
the spreadsheet as I scroll down?

I am trying to open a workbook and rename the 255 sheets without having to
individually rename them. Is this possible? Also is there a way to open a new
workbook with sheets names other than sheet 1, sheet 2, ect.?