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").....
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Outlook 365 overriding formatting choices 0
Using FIND to highlight text (with dashes) 4
Sum with multiple conditions and wildcard 2
Outlook Desktop (latest) stopped syncing IMAP accpounts from selfowned Mail server. 0
Wildcard not working in SumProduct Array 8
Macro for intelligent wildcard pattern modification 3
Use of Wildcard characters with replace 2
Synchronization problems while moving folders to new email 1

Top