I need to have the total count of times "Seller" "Landlord" and "Both" appear in column E in 2005.
Obviously, if I add anymore criteria in this formula it will require the entry to have all three categories in order to count it.
=COUNTIFS(Deals!$E$2:$E$500,"Seller", Deals!$C$2:$C$500,">=1/1/2005",Deals!$C$2:$C$500,"<=1/1/2006")
Is this a function for SUMPRODUCT?
Thanks!
Bookmarks