I am using an autofilter on a set of data. I would like to use a countif
field to summarize the visible cells only. So, every time I change the
autofilter I would change the criteria counted.
Any ideas out there?

I have data in a column format (eg Cell A1:A12)
It is possible for me to transpose the data into a row (cell C1:N1) using
the offset function?

My question is: I have 25 model numbers and each of them has 4-
differnet pieces. I have them setup in Excel with the cost price o
each and would like to generate retail prices based on a certai
multiplier..such as 2.5 times the cost. To further add to the mix, m

Can I create a button to refresh all the formulas. The IF statements
don't update when new information is input.

I am trying to create a formula to count a range of cells only i
another range of cells is greater than or less than a certain number.
ex.
count a1:a30 if the corresponding T cell is greater than 1 and les

How do I hide and unhide the same columns without reselecting the same colums
each time?

How can I write a formula that will count all null cells within a column, but
only if another column is also null for that row?
Situation: I am using Excel to track training of personnel for the
company.(I know, it would probably be better done in Access. Still teaching

Sometimes I get numbers from others to Excel, but when I try to make simple
calculations I cannot. I though the problem is about formatting of the
numbers. Apparently,  this is not the case since even if I re-format it as
number the problem persists. I was wondering why?

I am creating a time sheet on Excel. I have a colum for time in, time
out, and total hours worked. In the total hours worked column I had to
use the formula: =((C8+12)-B8)-0.5
The -.05 refers to the half hour lunch that is not counted as hours

i have 12 worksheets, 1 for each month
column a  has dates
03/10/06
03/10/06

Can someone help with the following.
I need a formula that will select the appropriate value based on a range of
dates:
I have 17 dates that are used to determine a proration based on a specific

I have several spreadsheets which contain calculations based on a master
sheet called FT_Data. I ran the exact same calculations on another dataset
which appear in a sheet called PT_Data. What I need to do is copy the
formulas now referencing FT_Data to another location in the ...

Any suggestions on how I could extract text from multiple cells (in a row) to
be included in one cell.

Does anyone knows a function or formula that would add the digits of a
number and spit out a result?
Example.... take the number 1092836103274 (all by itself in a cell)
add the 1st, 3rd, 5th digits and so on to get 1+9+8+6+0+2+4=30

I have two questions. In my workbook I have multiple sheets. I have one for
every day of the month. These need to be passworded. Is there away to apply a
password to just these sheets at one time instead of doing them one at a
time.I have a total of 45 sheets in workbook the ...