I have a spreadsheet that I use the Subtotal function to total values in
Column G based on items in Column A.  Column A contain branch names, and
column G contains invoice totals for invoice numbers in column B.
For example, after performing SUBTOTAL, I get the following results:

I am using Tools > Data Analysis > Regression to generate a "Summary Output"
and am trying use a formula / function to generate some of the data in that
output.  I have been able to recreate the R Squared, Slope and determined
that the t Stat is the slope of X Variable 1 divided ...

I have a 9 unit hotel and I can only create a 2005 or 2006 calendar in Excel.
How do I get a 2005 to 2006 calendar that is all on the same template?  
Thanks.  You answer with a solution- I'll give you a discount on a room.

I have data in 4 columns, I want to look at two (or three if it works)
columns and if data matches, put 4th column data in that cell.
Ex.
Here is my source data.

I am doing a template regarding standard usage of an item.  It has negative
and positve standard usage. How can i add all negative?

I have a data table with 5 columns and 18 rows. I have data validation
pull-down menus in separate cells, one each for selecting the column and row
headers data. In a third (adjacent) cell, I want to return the value that
corresponds to the selected values in the table. Seems ...

Hi... I am hoping someone can help me?
I have a workbook with a huge amount of data in it.  This workbook
feeds a number of other spreadsheets with data.  The idea being, when I
update the main wookbook data, it updates the other spreadsheets

I would like to subtract 10 days from a date automatically on the first of
the month.  How can I do that?  Please speak slow, I'm new

Couldnt find the answer with extensive searches:
Does the Round function round the number of significant digits stored in a
cell, or does it round the number displayed?
I believe it to be the latter, but need confirmation.

How do you make a formula that sais that an employee started work at 4am and
finished at 1030 am i need the answer to 6.5 hrs.  The problem would read say
in cell a1    "0400" in cell a2  (1030) and then I want cell 3 to display the
amount of hrs as 6.5 not 6.3?

I was playing around with these two functions...
=SUM((A1:A10)*(MOD(ROW(A1:A10),2)))
=SUMPRODUCT(A1:A10,MOD(ROW(A1:A10),2))
The first formula being an array function (you have to press

I have a table like this (more or less)
A                        yes
B                        no
A                        no

I have confirmed in general properties that the document is not a read-only
doc, yet I cannot enter any characters.  Why?

I am trying to convert minutes into fractional hours but I don't know how. I
already have a spreadsheet with over 100 employees and the overtime minutes
they have worked. I want to change all to fractional hours instead of
minutes. I think that's what it's called... you know 105 ...

How do I make this function work if I have one field with a List to choose a
name from and another with the fax number of that person in it.  How do I get
the fax to populate based on the name choice?