You might try:

=SUMPRODUCT(--(Overall!O31:O1026=MONTH(C28)),
--ISNUMBER(SEARCH(A35,O31:O1026)))




In article ,
"roy.okinawa" wrote:

I am trying to use this formula to sum/count from another worksheet. What am
I missing? I keep getting a FALSE answer instead of numbers.

=SUMPRODUCT(Overall!O31:O1026)=MONTH(C28)--(ISNUMBER(SEARCH(A35,O31:O1026)))