You dropped a comma between arguments. You dropped the --() when you were
checking the month.

And I think the rest depends on what's in your data.

If Overall!o31:o1026 contain dates, then you're missing month() surrounding that
range.

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

(all one cell)

Also, you used o31:o1026. Did you mean to use o31:o1026 of the sheet with the
formula in that last portion? But if that's true, then I'm not sure what you
want to do with that last argument.

You may want to describe what you're doing in words.

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)))

--

Dave Peterson