I followed the help menu to try to use the countif function, but it
just doesn't work out. I used direct copy from the excel help menu, so
that the function could not possibly has any typo problem. Can anybody
tell me why my countif problem doesn't recognized by office? thx.

I'm working on a cumbesome spreadsheet (not my creation). I'm trying to
add a cell to formula (just a sum of numbers) and am getting a "formula
too long" message. I've never seen this before. Can I change it and if
so, how?

I want to create a simple invoicing from a list of table. Like what I have
below:
A          B                         C                                      
      D

I want my users (17) to enter the time into a cell by clicking on a little
watch that appears.  Is this possible?  I made them a calendar to select from
with the calendar control but need something similar for time...please...

I have some data in columns and just can't seem to find the right command to
use.
My data currently looks like this
Sector    Block Fuel   

I have a question according the Normal (or Gauss curve).
The function NORMDIST(x; mean; stdev;true) gives me the pourcent.
What is the function that gives me x when I want to select 95% of my
population.

I have a simple formula (=(L30/H30)*100) which works fine, However I would
like to set up my worksheet to not give an error while "L30 and H30" have no
values yet.
Then i can copy the formula down the column and enter the values when

Is there a switch I can use with weeknum function that will calculate week
numbers based on UK tax year rather than calender year?
TIA
Trevor

I have strings that are in Column A. These strings are composed of cities
and zip codes sample is below:
Castro Valley (94546), Castro Valley (94552), Danville (94526), Fremont
(94555), Hayward (94540), Hayward (94545), Hayward (94557), Oakland (94601),

Why when a try to sum a number of time entries on a spreadsheet who's total
should be around 192 (worked hours per month) does the total appear as 00:00.
This is despite uning the [hh]:mm format, timesing the whole by 24 and
numerous other 'ideas'

I need to calculate a year-to-date total from a list of daily production
values. Each day has individual production totals, and it's own daily total,
and I need to have the daily totals added up into an annual total elsewhere
on the worksheet. I have asked for help on this before ...

I have a sheet with 2 columns. One column the user enters one of three
possible values in the first column.  There is a piece of code in the
worksheet that based on their selection the second column will have a
validation list, relating to what they have entered in column 1.

When i copied formulas from D1 through D6, why is it that D2 to D6 valve is
the same as D1? But the cell refects the correct formulas.
A     B           C            D
1    122     455    577

I want to know what formula to use to find the total number of things in a
column. For example if 'Strawberry' is written in column 'J' 10 times, I want
to have a seperate page that shows that information.