Countifs Depending on a Date Range

[Timberwolf]

Hi all

Ok I know my coding is horrible. I have no training and just google, then make it work for what I need.

I have a table that checks several cells on two different sheets for a Part # then sums the number of times it finds that Part #.

What I need to now do is add to the below formula so it does the same thing but only if it finds the following range 'Table Maintenance Reports'!E$2:E$10693 ">=1/1/2018","<=1/1/2019"

Here is my current formula please don't laugh too loud

=SUM(COUNTIF('Table Maintenance Reports'!H$1:H$10693,[@[Item No.]]),COUNTIF('Table Maintenance Reports'!K$1:K$10693,[@[Item No.]]),COUNTIF('Table Maintenance Reports'!N$1:N$10693,[@[Item No.]]),COUNTIF('Table Maintenance Reports'!Q$1:Q$10693,[@[Item No.]]),COUNTIF('Table Maintenance Reports'!T$1:T$10693,[@[Item No.]]),COUNTIF('Table Maintenance Reports'!W$1:W$10693,[@[Item No.]]),COUNTIF('Table Maintenance Reports'!Z$1:Z$10693,[@[Item No.]]), COUNTIF('Table Inspection Reports'!H$2:H$10693,[@[Item No.]]),COUNTIF('Table Inspection Reports'!K$1:K$10693,[@[Item No.]]),COUNTIF('Table Inspection Reports'!N$1:N$10693,[@[Item No.]]),COUNTIF('Table Inspection Reports'!Q$1:Q$10693,[@[Item No.]]),COUNTIF('Table Inspection Reports'!T$1:T$10693,[@[Item No.]]),COUNTIF('Table Inspection Reports'!W$1:W$10693,[@[Item No.]]),COUNTIF('Table Inspection Reports'!Z$1:Z$10693,[@[Item No.]]))

Any help or advice is much appreciated but comments such as "My eyes are bleeding" or "Bburn your computer" are not needed lol Thanks all!