"William G" wrote:
I am trying to sum a range of numbers that have a few criterias
that are both vertical and horizontal.

See responses to the same question posted in m.p.e.programming.

For future note, please do not "multi-post": posting the same question in
multiple related newsgroups. It bifurcates any discussion, and it means
more effort for responders if they take the trouble to duplicate their
responses.

If you thought you "cross-posted", your news interface or news server
actually split them into multiple posts. So don't cross-post using that
interface and/or server.