| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Array formulas
I have a problem using array formulas in EXCEL 2002. When I use COUNT or
AVERAGE in an array formula, it treats blank cells as zeros instead of ignoring them. I can get around it by filling the blanks with text, but this is not always a good solution. Does anyone know of a better way, and why array formulas change the way that blank cells are treated? This is an example of the type of formula I am using =COUNT(IF(Weights!$B$3:$B$392='Weight Calculations'!$C4,Weights!D$3:D$392)) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Problem with Array Formulas and ISNUMBER | Excel Worksheet Functions | |||
| sumif and array formulas | Excel Worksheet Functions | |||
| Problem with named formula's | Excel Worksheet Functions | |||
| Using wild card characters in array formulas | Excel Worksheet Functions | |||
| VBA Import of text file & Array parsing of that data | Excel Discussion (Misc queries) | |||
Threaded Mode
