How to sum cell values with case sensitive in Excel?
It may be easy for us to sum cells based on specific value, but, have you ever tried to sum cell values with case sensitive. For example, in the below data range, you just want to sum cells based on “Apple” and ignore lowercase “apple”, how could you finish this task in Excel?
Sum cell values with case sensitive by using formula
Sum cell values with case sensitive by using formula
The following formula can help you to sum cells with case sensitive, please do as this:
Enter this formula: =SUMPRODUCT(--(EXACT($A$2:$A$15,E1)),$B$2:$B$15) into a blank cell where you want to put the result, and then press Enter key, the sum result you want has been displayed, see screenshot:
Note: in the above formula: E1 is the specific criterion you want to sum based on, A2:A15 is the column contains the criterion, B2:B15 is the column data that you want to sum. Please change them to your need.
Best Office Productivity Tools
Supercharge Your Excel Skills with Kutools for Excel, and Experience Efficiency Like Never Before. Kutools for Excel Offers Over 300 Advanced Features to Boost Productivity and Save Time. Click Here to Get The Feature You Need The Most...
Office Tab Brings Tabbed interface to Office, and Make Your Work Much Easier
- Enable tabbed editing and reading in Word, Excel, PowerPoint, Publisher, Access, Visio and Project.
- Open and create multiple documents in new tabs of the same window, rather than in new windows.
- Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day!