Try...
=SUM((COUNTIF(Fund,">"&{11999,21099,28730,58999,82000})-COUNTIF(Fund,">"&{12999,28729,33999,59999,84999}))+(COUNTIF(Fund1,">"&{11999,21099,28730,58999,82000})-COUNTIF(Fund1,">"&{12999,28729,33999,59999,84999})))
Assuming that Fund refers to A2:A10, and Fund1 refers to C2:C10, here's another way...
=SUM(COUNTIF(OFFSET(Fund,,{0,2},,1),">"&{11999;21099;28730;58999;82000})-COUNTIF(OFFSET(Fund,,{0,2},,1),">"&{12999;28729;33999;59999;84999}))
Note, however, OFFSET is a volatile function.
Hope this helps!
Bookmarks