Count or sum product of two columns to determine overdue and show the overdue as on hold

Good afternoon All,

Moderators I apologize if the title is not descriptive enough, or if the post asks too many questions. I'm not trying to be difficult, I really like this site and the help.

Need some more help with this tracking sheet. I had previously asked the overdue question a few days ago but for some reason neither formula works now. Not sure how I messed it up.

Cell C69/70 are the two formulas that are currently not working for me, I only need one total overdue count. The cell needs to show a shipment that went out late (column H is greater than G) and if todays date is greater than column G.

Cell C71 should show overdue that is on hold (h) there are only four; B29, 47, 50, & 58.

Cell C78 needs to show the overdue for just Edger's (e) shipments.

Any links would be greatly appreciated so I can learn this myself and not bother anyone. Any suggestions on how to send this summary page to powerpoint? Again thank you everyone for your help in advance.

BB4523