Formula Wildcard and/or Remaining Value

K

Kristi

Is there a wildcard character or other way to look
for "email" and pick-up all three of the lines
below...using a text string in a SUMPRODUCT formula?

email
email receives
email responses
 
A

Anon

Kristi said:
Is there a wildcard character or other way to look
for "email" and pick-up all three of the lines
below...using a text string in a SUMPRODUCT formula?

email
email receives
email responses
Click to expand...

How about this?
=SUMPRODUCT(LEFT(A1:A99,5)="email").....
 
Top