SUMPRODUCT Possibilities

**calli** · 07-13-2007, 07:30 PM

Hi,

I am using the following formual:

=SUMPRODUCT((A1:A2000=A3)*(ISNUMBER(SEARCH("Incomplete",B1:B2000))))

Is there any way to search for 2 criterias, more specifically, "Incomplete and Complete" with in the same column (B1:B2000).

Thanks in advance for any help.

Calli

**Bryan Hessey** · 07-13-2007, 07:47 PM

Originally Posted by calli

Hi,

I am using the following formual:

=SUMPRODUCT((A1:A2000=A3)*(ISNUMBER(SEARCH("Incomplete",B1:B2000))))

Is there any way to search for 2 criterias, more specifically, "Incomplete and Complete" with in the same column (B1:B2000).

Thanks in advance for any help.

Calli

Hi,

removed, -- see following post by daddylonglegs
---

**daddylonglegs** · 07-13-2007, 07:52 PM

If you just search for "complete" then it'll also pick up cells containing "incomplete" so perhaps

=SUMPRODUCT((A1:A2000=A3)*ISNUMBER(SEARCH("complete",B1:B2000)))

SUMPRODUCT Possibilities

LinkBack

Thread Tools

Rate This Thread

Display

SUMPRODUCT Possibilities

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions