Problems using Countifs and "greater than" with formula values

[ellywooo]

I have a master sheet that tracks attempts to contact customers. The values in the master tracker are all vlookup values pulled from multiple trackers, so every entry is a forumla. I am using CountIfs the find the date that the sales lead came through and the number of attempts to reach the customer.

We track single attempts in a different column than multiple attempts. To do this, I have created two columns:

Single Attempt:

=COUNTIFS('Sheet1[Sell Date],">="&$B$2,'Sheet1[Sell Date],"<="&$C$2,'Sheet1!Table4[Rep ID],Table9[[#This Row],[REP]],'HS Sheet1.xlsx'!Table4[Contacted],"1")

This forumla works fine, and counts all instances of single attempts. Counting the multiple attempts doesnt seem to work, I assume because I am working with forumlas and not straight numbers.

I've tried the following:
"<1"
">"&1

Any help would be so appreciated. I am losing my mind.

Cheers!

[Ron Coderre]

Something looks wrong in your formula:

Please Login or Register  to view this content.

Single-quotes are only at the beginning of a reference (none at the end?)
Is Sheet1 a table name?
Is Table4 a different table than Sheet1?
Is this reference in a different file?: 'HS Sheet1'.xlsx