| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
array formula
I have the following array formula:
SUM(($D$14:$D$1403=$B$1)*(F14:F1403<200000)* ($C$14:$C$1403=$B$6)))+(SUM(($D$14:$D$1403=$B$1)* (F14:F1403199999)*($C$14:$C$1403=$B$6)) I don't want it to count blanks, cells with "x" or, cells with 0. However, the <200000 counts 0s and blanks, and the 199999 counts "x"s? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Array formula SUMIF with 2D sum_range array | Excel Worksheet Functions | |||
| Array formula: how to join 2 ranges together to form one array? | Excel Worksheet Functions | |||
| Find specific value in array of array formula | Excel Worksheet Functions | |||
| meaning of : IF(Switch; Average(array A, array B); array A) | Excel Worksheet Functions | |||
| Array Formula - using LEFT("text",4) in formula | Excel Worksheet Functions | |||
![scrabtree[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
