I thought this was rather simple until I tried to do it. What I want to do is write an If formula that if True, use this SumProduct formula, if false use that...

"Single word subjects and anonymous posters" sure takes any enjoyment out of trying to find solutions and posting replies. You can get a free email address...

I want to see on a graph the results of a formula when one of its variable take all the possible values between of a range of values.

Further to my earlier post, one of the machines is using Office 2002 (XP) it doesn't like the Networkdays function, can anyone assist with a work around,...

One way =INDEX($A2:$F2,,MATCH(TRUE,LEN($A2:$F2)0,0)) entered with ctrl + shift & enter copy down 7 rows --

We have a sheet of quotes. In one column we record the date if a quote is sold. I want to get a count of the number of sales in a given month. I am trying to...

Hey all, I've been trying to think of a way to create a unique invoice number on a worksheet, say , every time it is printed, or saved maybe.. I'm assuming...

I know there's probably an easy answer to this, but in my Excel, if I enter data in several consecutive cells in a row, the enter key will then take me back to...

we have page overflow and date format issues with excel macro. this macro generates about 20 pages of charts... 18 of 20 are printing on two pages when we run...

Help!!! I currently have a vacation spreadsheet in which I need to create a column to show vacation accrual per month. Based on their length of service with...

I have two worksheets, one is zipcode: A B C data zip state wi53202 =RIGHT(A2,5) =LEFT(A2,2) giving me: A ...

DOES ANYONE KNOW HOW TO GET A DATE FORMATTED TO MM/DD/YYYY WHEN IT COMES TO YOU AS AN UNFORMATTED FIELD AS FOLLOWS 20031202 (YYYYMMDD) THANKS KEVIN

Hello, I have used Excel long enough to know that when you copy a formula and paste it into another, it should calculate the formula. It seems that I have to...

When opening excel spreadsheets the system randomly will display the following message: "Microsoft excel cannot open or save any more documents because there...

I have a spreadsheet that had 10 worksheets. How would I tell it to open to the 10th worksheet in a particular cell. If I save it with my pointer in that...

I have two seperate workbooks that both contain information. One workbook contains a user key followed with other relevent information. The other...

=SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(C1&":"&D1)),3)5)) where C1 holds start date and D1 holds end date. HTH Jason Atlanta, GA -----Original Message----- I...

How can I get a formula to show me the valid value in one cell if the other cell contains a zero. Example: Cell A1 = 26, cell A2 = 0 or "". Now to devide cell...

I know that you can type in = A2(being a date field)+ 45, and it will add 45 as the number of days and show the new date. Is there any way to add months?

Is there a way to apply formatting to one cell based on the conditions of another cell? For example, if A1 is equal to 10 then format C1 to red text. Is...