| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Fun With Functions
Thanks for your help! That worked perfectly.
KePaHa wrote: If they are numeric values like you show in your example, then =COUNT(A2:A12) should do the trick. "Liv" wrote: Hi there, I need help with Excel! Here's the scenario. My spreadsheet has 12 columns associated with each row. Each row contains 12 separate numbers within those columns. What I want to do is create a new column with a cell in each row that the following: 1. Looks for values in each cell across the row. 2. For each value Excel finds within a cell of the row, Excel should assign 1 point. 3. Excel then sums the number of cells in the row that have values (not a sum of the actual values in the cells) in this same new cell. IF cell value is greater than 0, then value=1. SUM values of 1 for each cell within the row. Here is an example and the new column the above details reference is # Mos True Jan Feb Mar # Mos True George 1 2 3 3 Kramer 5 1 Elaine 4 1 2 Thank you! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can I get Excel to determine the line curve formula without graph. | Excel Discussion (Misc queries) | |||
| User-defined functions created in Excel 2000 fail in Excel 2003 | Excel Discussion (Misc queries) | |||
| Database functions should use criteria in formula, as 1-2-3 does | Excel Worksheet Functions | |||
| Visible rows and functions that work | Excel Worksheet Functions | |||
| # of Functions per cell | Excel Worksheet Functions | |||
Hybrid Mode
