Move to next line

[bgkgmg]

I am using the SUMIF formula in sh1 B34 that refers to info in sh2 colC&D. I
want the next cell in sh1, B35, to copy the next cell in sh2 colD that
formula returns. I do not know where the first value in colD will fall so
the formula keeps adding the values in the first cell.
Thanks

 

[Max]

For better answers, post your formula