Sumif / index / match / vlookup / hlookup

I over complicate things. Need help.

Data tab with the name of each department listed 12 times (1 for each month Jan - Dec)

I have a combobox and many other things going on in the file but this one little thing is seeming difficult. Attached is a sample of what I'm looking at.

I want to sum the all of the cells in Data tab for each column if it matches cell A4 (Dept) and if it matches the GL account # for revenue and expense accounts. Formula would be in column D of first tab in sample file attached. I've tried research and little bit of everything.

Any help would be greatly appreciated!

in D10 and copy down

=SUMPRODUCT((Data!$C$6:$AL$9)*(Data!$C$2:$AL$2='Income Stmt'!$A$4)*(Data!$A$6:$A$9='Income Stmt'!$A10)*(Data!$B$6:$B$9='Income Stmt'!$B10)*(Data!$C$4:$AL$4<=EOMONTH(TODAY(),0)))

NOTE: I changed dates to date format (01/01/2016) etc and formatted as "mmm".

Compares date against last day of "TODAY()" i.e. current month

See attached file

Awesome thank you! I need it to sum up all of the columns that match the department. Basically for every revenue or expense account sum up Jan through Dec as opposed to bound by today's date. I removed the = of column B part where the revenue or expense name will be...matching the account # sufficed.

I'll try to work with what you gave me later in the day. Boss just gave me a deadline.

Amended as you require:

=SUMPRODUCT((Data!$C$6:$AL$9)*(Data!$C$2:$AL$2=$A$4)*(Data!$A$6:$A$9=$A10)*(Data!$B$6:$B$9=$B10))

Sorry I didn't see the date part. Please see attached. This should include everything you need. Let me know if you need anything else.

Data Sample for jkle4596.xlsx

Very nice! I was just able to get back to this project a few minutes ago! I initially thought SUMPRODUCT was the formula needed for the way I have my data tab set up and had tried it for this particular column but obviously I didn't get it right.

Thank you very much. The system generated reports here are not the best so I've been creating my own since I first started in 2015. Thanks to this forum as I've received some help that has been very beneficial. I now have given myself more work as my reports are now required of me every month. Thank you again.

Ok I'm sorry but with the 900 columns and 300 rows this is slowing the data loading when scrolling through the combobox list. I can usually scroll through the 80 items in my drop down list almost flawlessly and this sumproduct seems to be the culprit. Any idea on maybe a SUMIFS in an array between 2 dates?