COUNTIF not listed in A2:A79

Need a little help with this formula on the Totals tab in cell B80. I want it to count cells that do not match A2:A79.

=COUNTIFS(Input!$C:$C,">="&B$1,Input!$C:$C,"<"&EDATE(B$1,1),Input!$E:$E,"<>"&$A2:$A79)

I have attached a sample of what I am working on.

The data in B80 is the number of January rows in E (82) minus the total for B2:B79 (79) = 3

You end with total of 15 miscellaneous (as 2 records in E are "Use") so TOTAL of 248 - 233

John Topley has the right idea but we need to refine how we use what is in B82.

Formula:

Please Login or Register  to view this content.

This is simply all of the entries in Input that meet the date criteria, minus all the ones we found for other categories.

Edit: Posted before I saw his subsequent post. However, my formula does not require any changes to the sheet layout, just plug it in.

Originally Posted by JohnTopley

Jeff,
Being "pernickety" here!!!!

Just trying to solve the question. My initial comment referred to post #2, which had the correct strategy of taking the total number of items and subtracting the categorized ones, but O82 was not the correct subtraction. Post #4 looks like a workable solution, although my suggestion just goes right into B80 without adding other rows. If that's persnickety then I'll own it.