I know how to add by clicking the sum button but theres no other button to
select  any other mathmatical functions.

Column A has 4 variables (w,x,y,z)
Column B has 4 variables (v1,v2,v3,v4)
I am trying to count how many times Column B says "v2" when Column A says
"x".  We were previously counting Column B using COUNTIF, but we were not

A      B       C      D
Yes  No     Yes   Yes
No    No     No     Yes
No    Yes   Yes    No

I have a function that needs to add 3 years to a date field.  I am currently
adding 1095 days (3 years x 365) to the base number, but if there is a leap
year in those three, I'm off by one day.  How can I add three years and make
sure that the extra day is included if one year is ...

I have a workbook with five(5) sheets and I am trying to import data on sheet
four from sheet 2.

I have 6 categories with 5-8 subcategories for each. My worksheet is a
document log. On my worksheet I have a column for Categories and a column for
Sub-Categories. I want a drop down box under categories that only returns the
available categories. And when I choose that category ...

Everybody has been so helpful here, I was hoping not to have to bother
everybody with another question, but it was not to be.
My problem now is that I have a list of all workers, now some maybe gone for
whatever reason, which would be another list.  What I am trying to do is get

I have a file with 10000 numbers and I want them to be in "text" format. I do
the basics (format-cell-text) but only when I insert ' or edit the cell
(F2+ENTER)I have the right results. is there an easier way which is less time
consuming?

I'm only new to Excell.
I'm setting up a Car log book in excell. I need to keep track of Klm's (Miles)
I entered in my start and finnish klm's, Now I would like the 3rd cell to
subtract the total number of Klm's travelled for the day e.g:start 1111

Is there some way that just by passing over a cell in Excel it will
automatically insert the current date.. I think I've done this with past
versions of Excel.. but I can't seem to remember how I did it and I can't
seem to find any documentation on how to automate this task

I have a column with values that have up to 4 places to the right of the
decimal point (32.2514) and I simply want the whole value rounded up, and I
don't want it just to show the rounded up value, I actually want the cell
value to be 32 if the number is 32.2145.  please help.... ...

Is there a way to not have a blank or zero value not be counted in an average
function.  Example:
I have a spreadsheet that has a year's worth of data.  Currently, it is only
filled in through June.  At the very end, I want it to average some of the

Hi Not too good at maths, trying to produce a formula to calulate discounts.
if a>0.25 and b>10 discount =Z
if a>0.25 and b>49 discount =Y
if a>1 and b>10 discount =X

I am constatly entering client numbers and names in an excel
spreadsheet. What i would like to do it have a fomula in column b that
will return the client name that i type in column a. I could have a
master list of client to lookup from.  Can someone please help me with

I have two sheets, for short story purpose, we'll call them SheetA and
SheetB. SheetA has the data I am pulling from, to SheetB.  SheetA has columns
B(DAY-which is the day of the month the pt was admitted), and column
D(PHYNO-physicians number).  This sheet is updated daily, and ...