Sum Array
 

I have a Sum Array that is not summing correctly. What could cause this?

Sum Array
 

there are many possibilities
a portion of the array may be text even if they look like numbers
there might be hidden cells whihc are being added even though they are not
being shown
the calc may be set to manual, not automatic.

many others

What type of problem are you having and could you put a copy of the equation
on the message



"Payton" wrote:

I have a Sum Array that is not summing correctly. What could cause this?

Sum Array
 

I have a dump tab that all my data pulls from for the formula below.

=SUM(IF($A$100&$A$102&$A$103&$A104='Download Summary'!$B$13:$B$704&'Download
Summary'!$C$13:$C$704&'Download Summary'!$D$13:$D$704&'Download
Summary'!$E$13:$E$704,'Download Summary'!$F$13:$F$704))

The A's represent different criteria and the columns after the = represent
the columns those criteria are listed in. Column F at the end is where the
numbers would be listed and summed from.

"bj" wrote:

there are many possibilities
a portion of the array may be text even if they look like numbers
there might be hidden cells whihc are being added even though they are not
being shown
the calc may be set to manual, not automatic.

many others

What type of problem are you having and could you put a copy of the equation
on the message



"Payton" wrote:

I have a Sum Array that is not summing correctly. What could cause this?