| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Array? IF? LOOKUP? VBA?
Duh, of course!
Thanks Bob! Bob Phillips wrote: Sorry, should be =SUM(A1:A10)+COUNTIF(A1:A10,"red")*100 -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) wrote in message oups.com... What is the most efficient way to separately compute the sum of cells from rows 1:10, across [an array] of multiple columns, if I want to assign a numerical value of 100 to all cells that have the value "x" in the cell? * I am not allowed to alter the formatting of the worksheet, ergo the "x" values must remain in the cells; * I do not want to create extra (ghost) columns just to change the "x" values to 100. Essentially, I want to perform this function: =SUM(A1:A10) (and SUM(B1:B10), etc) while imposing the condition that =IF((A$1:A$10)="x",100,A$1:A$10) Thanks in advance for suggestions! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Use array for lookup value, to return array of lookups | Excel Discussion (Misc queries) | |||
| Is there a way to do this - without array or lookup? | Excel Discussion (Misc queries) | |||
| Lookup array | Excel Worksheet Functions | |||
| lookup array | New Users to Excel | |||
| Lookup "greater than or equal to" in lookup array | New Users to Excel | |||
Threaded Mode
