Updating a current formula for a report in a widget to include dates

I assume you are familiar with using cross sheet references. If that is the case, just make sure that your range references are the entire column in the data sheet.

For the date changes...

The first date would be changed from 

DATE(2019, 6, 1)

To

DATE(2018, 7, 1)

and the second from 

DATE(2019, 8, 1)

to

DATE(2019, 7, 1)

Ok. Start typing your formula...

=COUNTIFS(

.

A box will pop up underneath of where you are typing that has some formula help points in it. You will see a link in the top left corner of this box that says "Reference Another Sheet". Click on it. A new window will pop up. Select the other sheet from the list on the left (give it a few seconds to load). When it comes up, you will want to click on the corresponding column header to select the entire column (it appears as if this first one would be the column housing the Job Title).

At this point I recommend renaming your ranges. The range names default to "Sheet Name Range #". I personally like to change mine to "Sheet Name Column Name" (if the previously posted references are indicative of the correct names, this range would be "Email, Registrations and Webpages Job Title" with the sheet name being the bold portion and the column name being the underlined portion) just to keep things organized.

Once you have selected your range (and optionally renamed it), click on the blue box in the bottom right corner that says "Insert Reference".

.

After clicking on that, you will be taken back to the sheet you were entering the formula on, but it will now have the cross sheet reference.

=COUNTIFS({Email, Registrations and Web Pages Job Title}

.

Now we need to enter the criteria we are looking for within that range, which would be whatever title is in the Job Title column of the current sheet on whatever row the formula is on, so we type in a comma and then type in the cell reference (you can leave @row as is - there is no need to use a row number unless you are referencing a row other than the one that the formula is on).

=COUNTIFS({Email, Registrations and Web Pages Job Title}, [Job Title]@row

.

Now we type in another comma and enter the next range we want to look at using the previously listed steps for cross sheet referencing.

=COUNTIFS({Email, Registrations and Web Pages Job Title}, [Job Title]@row, {Email, Registrations and Web Pages Date}

.

Since we are looking at the same range for two sets of criteria (greater than one date and less than another date), we can actually incorporate an AND function to keep us from having to retype the range more than we really need to. The AND function requires a logical statement, so we will leverage the @cell function to tell the formula to look at each cell within the range individually instead of the entire range as a whole. Since we are just looking at the Job Title and Date for your formula, we can go ahead and close out the COUNTIFS after this one as well...

=COUNTIFS({Email, Registrations and Web Pages Job Title}, [Job Title]@row, {Email, Registrations and Web Pages Job Title}, AND(@cell >= DATE(2018, 07, 01), @cell < DATE(2019, 07, 01))

.

And there you have it... Cross sheet referencing and efficiency tips all rolled into one quick breakdown.

Let me know if you need further clarification or if something still isn't working for you.

Remove the parenthesis from around Status. Assuming your ranges are set properly, this should clear things up for you.