Counting Bins of Fish at Different Days and Different Sites

Background

I work with salmon. We have a Survey123 form with a repeat that bins the fish by species, size, date, site, and whether it has been microchipped. These repeats are then tallied for the site location and date. Unfortunately, if there is a mistake (say the fish was accedentally marked as a Coho instead of a Steelhead) and a new page in the Survey123 form is added for a new fish, the count is recorded and cannot be rectified, even if changed in the app. The survey123 exports two sheets: one with the individually measured fish, with the fish sometimes in incorrect bins, and the other that totals of these incorrect bins. Since the Survey123 has errors, I am now processing these fish counts in excel. I have rectified the bins of the measured fish sheet, through simple COUNTIFS. Now I am struggling to add them up in the RST sheet.

Problem

I believe the main problem relates to the date/time stamp of the two sheets. I am trying to line up the fish measured at a site with the day they were measured. Both the fish and the site have time stamps, both different. I feel that this is the major hurdle. After looking at a similar reddit post, I've tried:

=Rows(filter(MeasuredFish!C:C), (int(MeasuredFish!C:C) = int(RST_2026!E4))*MeasuredFish!D:D="RST_2026!D4")

Where MeasuredFish!C:C is the date and time stamp column for each fish, RST_2026!E4 is the time stamp of the site visit, MeasuredFish!D:D is the site location of the basin where the fish is measured, and RST_2026!D4 is the site of the visit.