I want to sum values in a column from more than one row,
depending on certain accountnumbers (sorted) in another
column. The problem is that the accountnumbers vary
from time to time. Guess the code must consist av some
kind of looping, finding the first accountno, some those
rows, then go down to find the next different accountno,
summing the values in the rows corresponding to that
specific accountno etc. Until there is no more accountno
to find. Finally summing the total sum for all the values.
Please see my attached example in Excel.
Rows and columns marked with yellow color, the values
go from =SUM(D10:D17) and the result shows in I17.
Then it goes on to the cells marked with red color.
The final sum shows in I4. =SUM(I17:I21)
Anyone who knows how to combine SUMIF with Looping?
Thanks in advance
Bjorn
Bookmarks