I'm trying to sum a row if it meets two different criteria.  Here's an
example.  Here I would try and add column C if column A was 123 and column B
was group A.  Or something similar.  I tried to used sumproduct (reading
other responses to similar questions) but I get #NUM! error ...

I have a column of values and want to find the mean.  How do I write the
formula

I need a formula that will sum column J based on if the word "Utility" is
found with the text in the adjacent cell in column E and if the adjacent cell
in column P = "Won".
This is what I have started with.

How can i create a loan amoritization table

Can someone please help me with the following.   I am trying to lookup values
in 2 sets of data to provide 1 list with all unique records.   For example:
Range a: 1, 2, 3
Range b: 1, 2, 4, 5

I have a log, containing 4 columns.  First 2 columns contain dept name and
team name respectively.  Third column contains a timestamp at which the row
was added to the spreadsheet.  By design, we always add a row at the end of
the existing list (thus an append, never an insert ...

I can't find my previous question.  I want to lock just the formulas.  I
still want to be able to add or delete rows and be able to adjust row height.
Any suggestions?

I am currently trying to add data together to get a total, once slight snag
the data is set out within different cells which are made of of individual
figures for different days.
Example

Dear mate,
I have 6000 client names and some are duplicates. I need to copy just the
first 5 letters of each client from the cell and place in the next cell. This
will help me to sum up all the ABCDE revenue as they are all same client with

I have 12 months of dealers information on 12 seperate tabs with 14 columns
for each dealer.  I would like to create a master list where serching by
dealer number will add each column for each month.
I've tried adding vlookups for each sheet and gave me problems.

I am trying to find a way for Excel to alert me if a series of numbers is
entered twice in the spreadsheet.  Currently, I have a spreadsheet that
resembles this:
Column A               Column B              

Hi, is it possible to format a background which will stay put while you
manipulate your data cells / insert rows on top?  That would be SO useful.
E.g.  I have a big table of data, and just for visual purposes, I want every
3rd line to be coloured, to make the table easier to read ...

I am tryiing to setup an automated command within excel for every 1/2 hr to
send a column in excel with data to large group of people through outlook.
I am using this code but it is not working out:
Sub AutoRefresh()

I am trying to create a report in excel format from a big spreadsheet.
because the spreadsheet in use is quite big we want to extract only the
relevant pieces of information from the report for a management report.
there are numerous filters on this report also..

Why does my "TAB" key skip a column in excel spread sheets?  It used to work
properly but I must have hit something>  Thank you.