Countifs(OR

Robert S Fike

All parts of this works on its own, but cant figure out how to make them work together.

=IF($Help$1 > April$1, COUNTIFS({888 - Job Progress Slab}, <=DATE([Help Lot Size]1, April1, 31), {888 - Job Progress Final CO}, ="", {888 - Job Progress Origination Note}, ="Spec", COUNTIF({888 - Job Progress Final CO}, OR(@cell >= DATE([Help Lot Size]1, April1, 31), @cell = "")), COUNTIF({888 - Job Progress Contract Date}, OR(@cell >= DATE([Help Lot Size]1, April1, 31), @cell = ""))), "")

Mark.poole

one thing I’m noticing is your not closing off your countifs

Robert S Fike

TYVM