| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
array to normal version formula
The range (Amt) from A1 to A300
may contain empty cells, numbers with leading letter "c" like c15, c-19 and also may contain normal numbers like 1,3,88 and so on. I'm seeking to sum ONLY amounts with the letter "c", I have an array formula =SUM(--(IF(LEFT(A1:A300)="c",REPLACE((A1:A300),1,1,"")))) which can do the task, in my case this coding portion is a part of a bigger formula. So please Help how to write it in normal version many thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Array formula: how to join 2 ranges together to form one array? | Excel Worksheet Functions | |||
| XIRR formula in non-normal struction | Excel Worksheet Functions | |||
| Normal Text in Formula | Excel Worksheet Functions | |||
| how do i make one part of my formula bold and the other normal? | Excel Worksheet Functions | |||
| Recover earlier version of excel sheet after new version saved? | Excel Discussion (Misc queries) | |||
Threaded Mode
