Countifs containing an OR option

New Contributor

I have a spreadsheet that identifies all cattle into different classes  eg; Cow Bull etc.

I want to use Countifs to select the number of animals by class @ a given date.  I need to use Countifs with an OR in relation Date of Sale  OR( DOS being blank or DOS being after the given date ):-


I Cant get the logic for the OR function to work..$H$3 is a date.


2 Replies
best response confirmed by Hans Vogelaar (MVP)

@jonh54 COUNTIFS is designed to return the count when ALL criteria are met. The OR logic will thus not work here. You'll need to sum individual COUNTIFS statements. Such a formula would then look like this:





Much appreciated will make the changes.