Thread: SUMPRODUCT not recognizing text criteria

Hello,

I would like some help in determining if this formula is looking for what I want it to.

This is a simple personal check register sum return split up by month and by bill name, however I keep getting a zero sum (no error).

=SUMPRODUCT(--('register - BoA'!$D$6:$D$150="*aes*"),--('register - BoA'!$C$6:$C$150="*May*"),'register - BoA'!$F$6:$F$150)

are the asterix's in the correct places to accept any variations of the names?

Please let me know if I need to post more info.

Thanks ahead of time!

You can't use asterisks in the Sumproduct for wildcards..

one way:

=SUMPRODUCT(--(ISNUMBER(SEARCH("aes",'register - BoA'!$D$6:$D$150))),--(ISNUMBER(SEARCH("May",'register - BoA'!$C$6:$C$150))),'register - BoA'!$F$6:$F$150)

but is the May mean the month of May...in a date cell formatted to include May?

Maybe it should be:

=SUMPRODUCT(--(ISNUMBER(SEARCH("aes",'register - BoA'!$D$6:$D$150))),--(TEXT('register - BoA'!$C$6:$C$150,"mmmm")="May"),'register - BoA'!$F$6:$F$150)