Formula Help, if possible

[ASmith70]

First thank you in advance for any assistance. I am attempting to create an income statement sheet that I want to pull data from 3 different tabbed sheets labeled Jan, Feb & March respectively. On the income statement sheet I have a list of rows with each having a separate account code with an empty cell to the right of them where I would like the amount column data from the 3 sheets to appear If the account code is used on any of the 3 separate sheets.

 

[mart37]

Have you tried 3x SUMIF?

 

[ASmith70]

Have you tried 3x SUMIF?

I have not. Time for me to now research that

 

[ASmith70]

Have you tried 3x SUMIF?

Mart37 - I have performed the function below and is working perfectly on the Jan 2021 tab but I am unsure how to add to the formula to add the next two tabs, Feb 2021 and March 2021 for them to all show up on the 1st Quarter Income Statement tab. Any suggestions?
=SUMIF('Jan 2021'!B2:B50,B7,'Jan 2021'!D2:D50)

 

[mart37]

=SUMIF('Jan 2021'!B2:B50,B7,'Jan 2021'!D2:D50)+SUMIF('Feb 2021'!B2:B50,B7,'JFeb 2021'!D2:D50)+....

 

[ASmith70]

=SUMIF('Jan 2021'!B2:B50,B7,'Jan 2021'!D2:D50)+SUMIF('Feb 2021'!B2:B50,B7,'JFeb 2021'!D2:D50)+....

Thank You VERY MUCH!!!!! I was having issues with the ( ) placements causing my error(s).