Hi, Can any one tell me the function/formula for how to sum (Add) only nagative(-) or only positive (+) values in a row/column. I have so many # which is...

I'm trying to create a pivot table that summarizes different community sales. The worksheet has over 5,000 records, but the column that contains the...

I have a large spreadsheet and I would like to search 3 of the colums for certain information. If any of the information is found in any of the 3 columns,...

How do I use the folowing formula and show the number with a unit seperating comma like 12,469? =CONCATENATE(SUM(F7:F26)," Brick")

I'm trying to find the date (which is in column B) of the LAST occurrence of a number (in this instance number 1) in column C. This formula only locates the...

I have one workbook with several sheets, i want to apply the sumproduct function. my file contains 4 week sheets & 1 monthly summary sheet on summary sheet i...

Hi All: I need a formula that will count the number of occurences that a column contains either "text string A" or "text string B".

I've got an Excel workbook with many worksheets in it. Each worksheet has the same three columns and one column (Name) has many duplicates across the...

I have a formula in a cell (A2+A3). It is possible that I enter an INDEX function in the same cell?

Hi, I wanted to create 3 dependent lists. For example: Col A Col B Col C ------ ------ ------ TaskA BAU Z101 TaskA PRJ Z002 TaskA PRJ ...

Hello, assume my cells ( e.g. A1:E10) are filled with words ( i.e. one word per one cell); I want to find specific character groups, so if I am looking for a...

Hi, I've been struggling with this for a couple of days... I'm trying to save an Excel 2007 worksheet as a web page, not a static web page - I can do that -...

I have a column with 20 rows and I am entering this function =INDEX(Av$6:Av$25,MATCH(ROW()-1,$ax$6:$ax$25,)) in the first row then I copy down till the 20th...

I need a multiple step formula for Excel 2003 that looks for a number Column L for an occurrence of a number. There can potentially be many blanks in...

Hi all, I have made manually fomula to check against PRICE function's result and i've found that the results are matched for all the coupon period except for...

I am trying to create a spreadsheet where by pressing a button on the front page it will take me to another tab where there is a rota of support person...

Hello All, I have a 50 worksheet file that has a summary on each page that I would like to summarize again on a summary page into broader categories. The...

Hi, could someone please help me with step by step instructions on setting up a drop down list for Excel 2007. The names of my files are as follows. The file...

I have an Excel07 table with several columns, some with text, some with numbers. I need to find a function to help me show a sum total (on another worksheet...

Can you copy the data from the Status Bar to another cell in the spread sheet. Example, select SUM on the status bar, select a range of cells, status bar...