Formula countifs with multiple criteria

**jpecor2** · 12-09-2013, 05:39 PM

Hello All,

I am trying to figure out a countifs style formula that takes a list a have and counts the number of items that match based on the following information. The problem is that one of the criteria can be either blanks or any date past a specific date.

=COUNTIFS(Vehicle_Class,"="&C64,Location,"=Main LPC",Date_Delivered,"<="&D$4,Date_Turned_In,{"",">=D$4"})

I need it to count by the following:

A vehicle being a certain class
Location being a specific building
Date delivered being before a certain date
A turn in date being either blank or having a date past a specific date (this is the part giving me trouble because its like an or statement)

Can this be done?

Thanks in advanced!

Joe

**Moo the Dog** · 12-09-2013, 07:40 PM

You could try:

Formula:

Please Login or Register  to view this content.

- Moo

Also, I should note that your profile lists Excel 2003, yet you are using a formula only available in Excel 2007 and later...

**daddylonglegs** · 12-09-2013, 08:00 PM

Hello Joe, you could try this version with COUNTIFS

=SUMPRODUCT(COUNTIFS(Vehicle_Class,C64,Location,"Main LPC",Date_Delivered,"<="&D$4,Date_Turned_In,IF({1,0},"",">="&D$4)))