Hi all.
My equation is as follows:
sumif(a1:z3,aa1,a4:z7)
I'm checking the range of a1 to z3 for all occurrences of the contents of
aa1. Once those instances are found, I want to sum all of the values within
the range from a4 through to z7, under the specified headings.
As you see, I've made my sum range 4 rows tall. I've done this deliberately,
as my data set has merged cells, that are 4 rows tall (part of our internal
requirements that have worked quite well thus far).
Occasionally, within the data set, there are rows that are not merged, and
have more than one row/cell with a value in it.
I.e., c4 = 2; c5 = 12; c7 = 2. Then a little further down the row, t5 = 32;
t6=1.
My problem is that sumif is not counting all values. It only appears to be
counting c4's cell value.
However, I have found that sum() will in fact count all of the four
individual cells. Unfortunately, due to the data requirements, I'm unable to
use just the sum function.
Does anyone know:
1- why this does not work?
Is there some restriction that only allows for a single row accounting?

2- how to make it work?
I noticed on one post that one party used an index function that allowed for
varying cells.
I.e.,

One way

=SUM($A$1:INDEX(A:A,D1))

where A1 is the first row and D1 holds the last row number

Thanks for your help, in advance.
Best Regards.