Would like to sum totals in a column based on data in two other columns - for
example - sum if col 1 = "fall"   and col 2 = "VT"  total col 3

I have a spreadsheet that we use to keep a record of requests for
information.  I have a workbook listing all requests over the last three
years.  We would like to create a new workbook for each year.  Without
copying and pasting, how can I have the new information that is ...

I have a workbook that I update every day on the call ins I recieve. At the
end of the week I have a total for all the calls that came in from different
sources. I want to know how to merge the prior weeks numbers into the next
weeks workbook so I have a Month-to-Date talley. Is ...

I am operating on two PCs one being an English version and the other a Danish
version. When I use Analysis Tools such as XIRR in English, then I have to
correct the formular to XIrr on the Danish Version. Consequently, I would
like to have installed Analysis Tools in an English ...

I have created a list of items to choose from in a drop down box. I would
like the user to be able to choose multiple items.

I have a spreadsheet with about 20 columns of data, 3 of which are
long-winded array formulas. I have some conditional formats and simple IF
functions in the other 17 columns. I would like to keep the sheet calc to
auto, but this makes entry slow because of the 3 columns of arrays. ...

I have 52 sheets in the same workbook.
Sheet 51 is a summary sheet, sheets 1 - 50 are detail sheets.
I would like sheet 52 to be an analysis sheet.
In the top corner of sheet 52 I would like to be able to put a code

It's useful to show the sheet name or workbook title in a cell within the
workbook.  What formula works best for this.  It's important that the sheet
name not change when I'm active on another sheet (i.e., active on the first
sheet, but printing several grouped sheets).  Thanks.

  Would you show me how to use counta to find the height of a range.  The
range is from the 7th row of a column to the last cell of the same column
(the column may not be the longest).
Thanks,

  Please help me with defining a name range using offset.
  I need to set up a name per column using dynamic range.  Each Column
starts at row 7.  Data are appended to row (and it will grow and I don't know
how many rows before hand, and the column does not contain empty cell.

i have a list of figures, both + and - , some of which i know when added
together give a specific total.  how do i find which figures from my list are
the relvant ones?

I have my advanced Excel ECDL assessment in the next few days and I can't
figure out how to do something.  I have to add a function to calculate the
projected sales increase using specific conditions, does anyone know how to
do this?  This probably isn't a hugely complicated ...

I have 51 sheets in the same workbook.
The front sheet is a summary sheet of the 50 behind.
Each sheet has a list of codes with a value next to it, but the same code is
not on the same line in each sheet.

I have the need to create a quantity summary of information from two types of
text
It is as follows: (all columns have a list of information from which a word
can be choosen - no text can be inputted)

In a row of 52 cells, each cell contains an X or a P or an N.  I want to
calculate the number of cells that contain an X and divide by 52 (or COUNTA
of the cell range).