Hi there, I'm hoping to get help with a report, that I want to automatize.
The data are organized in the following way - for example - cell A1 - reference, cells A2-A150 contain the description "transaction", cells D2-D150 contain the values; then cell A151 is blank, cell A152 contains new reference, cells A153-A220 description "transaction", cells D153-D220 values etc. I'm struggling to formulate a formula, which would ensure, that the values belonging to the respective reference are summed. Certainly, the transaction count varies. So basically I need to somehow instruct excel to find specific reference and get the total of all transactions from the area defined by the reference position and the very first next blank row.
Can anybody help?
Many thanks in advance.
Bookmarks