This is been difficult. If I reference a value within A10 that is not located in the table, #N/A is returned. How can I make it so that the cell remains blank...

I had some help putting together this formula, but it has been giving me some grief for some reason after it seemed to work ok to start...

How do I make the status bar larger so it is easier to read the sum number in the status bar. Or... is there a way to display the sum of highlighted cells in...

I have 2 worksheets in a file; the first is titled "Schedule", the second is titled "Master". On the second work sheet I need a function that says, in...

cells A1:L1 represent monthly expense totals from January to Dec. cell M1 is the sum of the 12 months. I am trying to create a formula for cell N1 that...

This was previously discussed but needs additional clarification, sheet1 (WS1) represents 2008 monthly expense figures from Jan-Dec in cells A1:L1 and M1 is...

I am using the following formula but it will involve nesting 12 functions. I understand the limit is 7. Is there a way to write the formula to avoid the...

I have tried the following formula as suggested by your discussion group Feb4, =sum(WS2!$A$1:index(WS2!$A1:$L1,countif($A1:$L1,""&0))). The formula should...

I want to put a green data bar if the value in R30 is 0 or a Red data bar if R30 is 0 , and finally a yellow data bar if R30 = 0. I am calculating math...

I am trying to limit the cells another user can access on a sheet by the condition in another cell. In cell A1 input name in cell B1 opt for single or...

after locking and then protecting cells, how can i prevent these cells from being selected. What i means is usually when you place the pointer over the cell...

every time I choose print entire workbook and then hit ok the next time I go to print, the button moves back to print active sheet. how can I keep it on...

IM SWICHING TO EXCEL 2002 FROM 2000 AND CANT SEEM TO FIND THE INVOICE FUNCTION UNDER TOOLBAR TO BRING UP THE BOX FOR AUTOMATIC NUMBERING OF THE INVOICE NO. ARE...

Hello, I have data in the form of: DATE AMOUNT like: June 1, 2002 $100 June 5, 2002 $100 July 1, 2003 $125 Aug 9, 2003 $150

I'm using a SUMIF/COUNTIF formula to average columns of data based on criteria entered by the user. I have a separate cell designated for the user to enter...

I am trying to build a formula that will do a vlookup across multiple sheets and give me the sum of the results in a summary page. Here is what I have...

Hi I am trying to create a graph on sheet 5 of a workbook for exapmle. How do I link the data from other sheets on the same workbook to create this graph...

column A contains numerous numbers. i want to create a validation list in another cell using this list. i know how to create the list but i would like to know...

I have an Excel 2002 workbook which has many worksheets. One of these worksheets is a TOTAL of the other worksheets. One cell in the TOTAL worksheet is using...

I'm trying to calculate monthly inventory usage from data retrieved from daily usage reports. The formula below works, but not sure how to ignore rows with...