Functions

Counting formula
I need a formula to sum on the cells that match a variable in another cell A B C D E F G H I 1 2 Bo Jim Ron 3 3 2 6 4 1 2 3 4 5 6 ? ? ? What I need to be able to do is sum the number of columns (A4:F4) that matches the numbers in G3:I3. So, t... 19 Mar 2010 23:29

Moving Cell Formula
I have a spreadsheet with a summary page and several worksheets following. My formula calculates from a column of data that is updating with new information each week. How can I set up a formula to automatically select the cell below with the new data? ... 20 Mar 2010 23:17

Vlookup problem
I am having a problem with a vlookup fromula returning an #N/A value when using a cell with another vlookup formula as the lookup_ value. I created this same spreadsheet a year ago and it worked fine. I even opened the old one and I can't see any differences at all. I'd appreciate any help anyone can give. -- ... 19 Mar 2010 20:09

Making an excel sheet so formulas can not be deleted in the sum to
Making an excel sheet so formulas can not be deleted in the sum total yet in the other cells used to add up to the sum total cell a numer can be added. I tryed locking only the cells that contain the formula under the Format Protect tab, but the formula could still be deleted by hitting the space bar or enteri... 19 Mar 2010 20:09

Protect cell but allow copy command?
"Jay" wrote: Yes, go to the cell right click and select format cells from the pop-up menu. Then go the very last right tab and place a check mark in locked and hidden check boxes, click OK. Then go back to the main sheet and select protection from the "Tools" menu, there, select "Protect Worksheet"... 19 Mar 2010 17:50

sumproduct with 4 conditions
i need to have a single formula that will count the number of times 4 different conditions are met. I 2 types of members, in 3 different markets. i need to identify, the member type A, from market A, during January, that is not duplicated. i have the date converted to a text field in column B (labeled all jan... 19 Mar 2010 19:02

If then between two dates
I am trying to distribute revenue evenly between two dates. I have in one cell the beginning of the project. I have in another cell the end of the project. One my spreadsheet, I am referencing the month to determine if it falls betwen the project dates. I thought it was an if(and statement but it doesn't return... 19 Mar 2010 16:41

Posting the workbook
How can I post the workbook I am in so someone can help me with IF, INDEX and MATCH combination formula? ... 20 Mar 2010 12:06

Vlookup with variable column reference
Help! I am trying to link two workbooks with a vlookup that searches for the last populated columns' entry in a range (see example below). 27/03 28/03 29/03 30/03 31/03 Data 6 4 Is there a way of doing this in a function? In a macro I would use the Range().End(xltoleft) code but I cannot figure out how ... 19 Mar 2010 17:50

Vlookup with If condition
I meant this to go under Excel Worksheet Function. My apologizes for the repeat. A1 A2 A3 1 3 4 2 5 6 3 6 3 4 7 8 5 3 2 6 2 1 7 3 9 I am trying to find a combination formula that looks at column A2 for a specific value from another cell (say... 19 Mar 2010 15:32