Countifs FOrmula Not working

**cartica** · 10-30-2013, 01:29 PM

HI-

I am trying to count the # of occurences of MXN, and HKD in column E, when the fund name is Master. My formula is only returning the number of occurences of MXN. Can someone help me with my formula. Thanks

Please Login or Register  to view this content.

**XOR LX** · 10-30-2013, 01:34 PM

Hi,

Combine it with a SUMPRODUCT to coerce an array of returns:

=SUMPRODUCT(COUNTIFS(Sheet2!$E$2:$E$5000,{"MXN","HKD"},Sheet2!$G$2:$G$5000,"MASTER"))

Regards