Step-by-Step 1 – Using the SUMIF Function

The Convert Text to Columns Wizard opens with Delimited selected as the default, because Excel recognized that the data in the selected range is separated with delimiters. Click . Next. 4. Select . Comma . and . Space . as the delimiters. If other delimiters are checked (such as Tab), deselect them and click . Next. Click . Finish. 5. ................
................