Count Question

[Treasured2005]

I need a count to work in an aggregate formula. My goal is to extract records that have multiple criteria. I am using steps from this YouTube video to try to make this work. He starts talking about the aggregate formula around minute 19, if you decide to look at it.

This is the user interface with drop-down boxes for each underlined word.

My count formula looks like this right now, but it is returning a value of 0 which is incorrect: =SUMPRODUCT(--(ISNUMBER(SEARCH($L$3,'Seed Database'!B:B)))*('Seed Database'!$E:$E=February!$J$3)*('Seed Database'!$A:$A=February!$K$3)*('Seed Database'!$C:$C=February!$N$3)*('Seed Database'!$D:$D=February!$P$3))

This works by itself: =SUMPRODUCT(--(ISNUMBER(SEARCH($L$3,'Seed Database'!B:B))))

and

This works by itself: =SUMPRODUCT(('Seed Database'!$E:$E=February!$J$3)*('Seed Database'!$A:$A=February!$K$3)*('Seed Database'!$C:$C=February!$N$3)*('Seed Database'!$D:$D=February!$P$3))

Can I combine them? If so, can you help me do it?

This is what the Seed Database looks like for reference:

 

[Rijnsent]

You're almost there, try this (notice I moved one closing bracket to the end):
=SUMPRODUCT(--(ISNUMBER(SEARCH($L$3,'Seed Database'!B:B))*('Seed Database'!$E:$E=February!$J$3)))
Cheers,
Koen