Help in formula to sum deposits from different sheets

Hi FDibbins,

Thank you for the reply,

I did add data, rows: 20,21,22 and 24,25, also there is data in rows 39,40.
these are the cells (white cells only) that I need to collect and sum with month's title criteria.

so, I need the formula to lookup for the month "Apr-2018" in several sheets and sum the amounts in the white cells below it.

Thank you for your help

Dear FlameRetired,

first thank you for your help, it is much appreciated, the principle is very good, I checked it out, let me tell you this:
1. workbook consists of 10s of sheets,
2. all sheets in workbook are identical, I worked on a main sheet (or original you can name it), then all clients data were inserted on copies of this sheet.
3. the problem with months not in order is when the client joins the company's plan, thats why a client could start his table with Jan-19 and another with Mar-18 and so.
4. deposits are divided on two sections, rows 20,21,22 are for first deposit/deposits (month that the client joined) and rows 24,25 are for additional deposits made by the client in the following months, cannot put first deposit and second deposits on the same row as they fall under different conditions.

This is basically how it works, now, I worked on your formula, conclusions:
1. it is summing only the first cell (B20), based on your logic, if I add any numbers in the rows 20,21,22 it should sum them, which is not happening, that is not bad for me, because I want only the first deposit from those rows, other added numbers should not be summed because they are reinvestment and not deposits.
2. if I change the row numbers to 24,24 it is working as well but only for the first cell (B24), here it is crucial to add all the cells, because a client might deposit in the next months as well.

hopefully my explanation helps.
Thank you for your help.

avk, thank you for the suggestion, sheet1 wont help me much, and I cannot change the structure right now as there are 10s of active sheets with more than 18 months data on.

but still thank you for taking the time and reply

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.
Read this to understand why we (and other sites like us) consider this to be important.

https://www.mrexcel.com/forum/excel-...p-formula.html

Thank you Pepe Le Mokko fpr bringing this to my attention, I do need this help urgently if possible thats why I did cross posted.

I cannot post my cross post link, receiving this error:

The following errors occurred with your submission
You are not allowed to post any kinds of links, images or videos until you post a few times.