Dynamic COUNTIFS Formula

[reberryjr]

I'm trying to build out a dynamic Countif formula, so that as additional records are added, results are counted. The underlying formula works for a static range, but I need to be able to count new records as they're added, without having to manually update the range references.

=COUNTIFS('EN3485 Tracking'!U3,"Pending Submission of Changes - Late",'EN3485 Tracking'!B3,"Letters")

 

[AlphaFrog]

This will count the entire column where both conditions are true. The COUNTIFS function only counts to the last used row on the sheet.

=COUNTIFS('EN3485 Tracking'!U:U,"Pending Submission of Changes - Late",'EN3485 Tracking'!B:B,"Letters")

 

[reberryjr]

This will count the entire column where both conditions are true. The COUNTIFS function only counts to the last used row on the sheet.

=COUNTIFS('EN3485 Tracking'!U:U,"Pending Submission of Changes - Late",'EN3485 Tracking'!B:B,"Letters")

I tried that earlier, but I must've left the colon out. SMH. Thank you!