If, countif, range, index formulas on different sheets

Hello everyone,

I require some help again with cross-sheet formulas. I'm just not sure where to start or how to format them properly.

I have attached the sanitized workbook.

Here is the flow I need to occur:

• Data is entered from a source in either SAFE PRACTICES or INSPECTION FINDINGS tabs on a rolling daily basis.
• Then in each monthly tab, the data needs to be totaled as shown (automatically) if:

• It matches the date for the tab
• SA Referenced equals "Yes"
• Then totals it as shown by the SA Type
  

I hope this makes sense.

Thanks for the anticipated help!

Try these:

C4 =COUNTIFS('Safe Practices'!$A:$A,">="&$A$1,'Safe Practices'!$A:$A,"<"&EOMONTH($A$1,0)+1,'Safe Practices'!$C:$C,"Yes",'Safe Practices'!$D:$D,C$2)

C5 =COUNTIFS('Inspection Findings'!$A:$A,">="&$A$1,'Inspection Findings'!$A:$A,"<"&EOMONTH($A$1,0)+1,'Inspection Findings'!$C:$C,"Yes",'Inspection Findings'!$D:$D,C$2)

Drag both formulas across through column I.

That works perfectly!

Thank you so much for the help!