Excel SUMIF/COUNTIF contains text

Use the SUMIF function as shown in the following formulas:
1. =SUMIF(A2:A7,”Excel”,A:A)- Only Sums Excel
2. =SUMIF(A2:A7,”Excel*”,A:A)- Starts with Excel
3. =SUMIF(A2:A7,”*Excel”,A:A)- Ends with Excel
4. =SUMIF(A2:A7,”*Excel*”,A:A)- Contains Excel
5. =SUMIF(A2:A7,”???”,B2:B7)- Is Three Characters.

 Excel Training Class in NYC or Online that teaches this information.


Leave a Reply

Your email address will not be published. Required fields are marked *