Formula Wildcard and/or Remaining Value

  • Thread starter Thread starter Kristi
  • Start date Start date
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
 
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").....
 
Back
Top