| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Summing Boolean
Hi,
XL2003 I would like to Sum a named range of cells containing only True or False or blank. I tried: Application.WorksheetFunction.Sum(Range("MyRange") ) But this gave zero, even if 'True' was present in the range. And BTW, is there no SUM function in VBA? I think I can use AVERAGEA, then multiply by COUNTA(MyRange), but that seems a bit extreme. Regards - Dave. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Boolean Math | Excel Worksheet Functions | |||
| IF vs Boolean | Excel Discussion (Misc queries) | |||
| More on Boolean | New Users to Excel | |||
| VBA Boolean | Excel Discussion (Misc queries) | |||
| Boolean masks | Excel Worksheet Functions | |||
Threaded Mode
