Would someone tell me why the following doesn't work? Thank you.
=COUNTIF(Aliberti!G40:G53, ">=Aliberti!G6")

I just threw this together, but in the interests of learning more about
Excel, I'll ask if there is a better way. A co-worker had a whole list of
dates and he needed that date +30 months (so that the end day would be the
same as the start day, so it has to take into account the ...

What i'm wanting to do is create a form and leave my first line visible
regardless where I am in the document.  I want to make sure that I can see
rows 1 and 2 even if i'm on row 9999

I need to highlite a cell that has a date and is over due 365 days or more
from todays date. Having trouble with conditioonal formatting

I'm trying to calculate a ratio then print the ratio in a report.  The format
I want to use is 4.5:1.  

Hello everyone.
I am hoping some one can help me with what is probably a fairly easy
problem that I can't seem to figure out. :rolleyes:
I have a worksheet that I need to enter a function that will

I need to subtract a number from a percentage.  i dont know how to make
it into a formula that is correct.  the percentage is 10.
ie. 9.00-10%.

I have a VLOOKUP formula which matches values in 'Col A' to a spreadsheet
which, when opened, the values in 'Col A' are merged across A,B,&C.  The only
values which are returned are those whose entire name is within 'Col A'.  
Those which extend (merge) over columns B & C are not ...

Does anyone have a list of hotkeys or tips for in cell editing besides
alt+enter for a new line?
Thanks in advance for your help.

I have a spreadsheet that has dates in the columns. When the date is older
than 365 days, i need that cell highlighted red. Any help would be appreciated

I have a purchase order spreasheet working with. I would like it to
automatically generate a unique identifier (PO number) upon opening the file;
is this possible? or some formula to automatically pull in the next
sequential #?

I need a function to give two conditions in a SUMIF formula and don't
get round it on my own.
I need to calculate e.g. if column A is Revenue and column B is HQ,
then sum up column C.

I want to return a value (a number) based on a number in anotehr cell that is
within a range of numbers using the IF function. For example: A2=$75 if B2=5,
A2=$100 if B2=10, A2=$150 if B2=15.
Can someone please give me the correct syntax, I am really lost!

In Excel 2002, I have a problem that I can’t seem to solve. I gave this to
our company Excel Super User who usually solves things like this in a matter
of minutes, and she couldn’t get it to work either. I’m hoping some brilliant
mind here can help out.

I have a row with class grades in it and I want to be able to automatically
find the lowest grade and add the bonus points to it.
Ex:  Column A - 85   Column B - 98  Column C - 75  Column D - 100  Column E
- 5