Hello,

I'm trying to use the Countifs function to display the results on a 'Master' sheet using data on a sheet named 'DFW_FM'. I started by using the function that I was able to get working on the 'DFW_FM sheet then tried to modify on 'Master' to display the results in a paticular cell. Unfortunately, it's not working. Below are the two functions I've been using. The second has been tweeked a little with 'not working' being the final result. Not understanding what's wrong with it. Any help you can provide would be appreciated. Thank you.

=COUNTIFS(D:D,"=UPT",A:A,">="&E3,A:A,"<="&E4) This one works.

=COUNTIFS(DFW_FM!$D:$D,"=UPT",DFW_FM!$A:$A,">='Master'!$B4",DFW_FM!$A:$A,"'Master'!$<=B5") This one doesn't.