Once again I am back here asking for some help, you all have helped me learn a bunch of new things and helped me in the past so here's my problem.SumIfArray_Issue.xlsx I have attached an example to better explain my issue. Basically i have an array of data with 5 variables that I am trying to sum for. I can get the index array put together but I can't think around the problem to solve for the problem of needing to add together multiple points within the array to get my total.

The sample is much smaller and simpler than the actual but the idea and number or variables is consistent.

Any help is greatly appreciated.

Thanks again,
smls