Help in SUMIF formula

[Clwd9Rider]

Hi all, I need your help in the below issue

need: sum a production table based on months deposits.

what I have: 1: sheet for each client with a table of deposits monthly based

2: all amounts in same rows of all sheets, but months are in different columns

what I want: to sum months deposits in my master sheet.

for example: in sheet1 the month Sep-18 is in D5 and amounts in D6 D7 D8, in sheet2 the month Sep-18 is in E5 and amounts in D6 D7 D8 ...etc

Thank you in advance for help

 

[Clwd9Rider]

Just a small correction in the example: for example: in sheet1 the month Sep-18 is in D5 and amounts in D6 D7 D8, in sheet2 the month Sep-18 is in E5 and amounts in E6 E7 E8 ...etc