Most valuable professional
  • Hot Topics

Excel Formula Inconsistent

Windows 7 Professional Excel 2013 Good afternoon, Trying to understand why my formula works on certain words and not others. My target worksheet, DB_Activity Col - $D$2:$D$1000 consists of 36 ?Expense Descriptions? and Col - $E$2:$E$1000 consist of the cost associated each Description. The following formula works fine with the below list with the exception of those with an **. =SUMIF(DB_Activity!$D$2:$D$1000,"Other",DB_Activity!$E$2:$E$1000) ** Accounting Service ** Advertising Auto Lease Insurance Auto Lease Payment Auto Maintenance Bank Fees Bank Supplies Cell Phone Computer Hardware Computer Software Corporate Fees Credit Cards Deposit Entertainment Fuel Gifts Internet/High Speed Laundry/Dry Cleaning Legal ** Licensing Lodging

This question generated 11 answers. To proceed to the answers, click here.

This thread is current as of May 5, 2015.

For more resources for Microsoft Excel:

This article includes the following tags:

  • Excel
  • Microsoft Excel