Free Online Tutorials on Spreadsheets

Sum by text in Excel

For subtotal of a range, based on text, SUMIF function is used. In our example below, we try to elaborate the way step by step:

1- Type “=SUMIF” in a blank cell and select a range of cells that you want to be evaluated using text criteria.

2- Select text criteria to be used against sum, e.g. in our example, type “A”.

3- Select cell range for addition against selected criteria¬†“A”, like in our example “B3:B9”.

4- Press “Enter” for the result.

5- For party B, repeat all steps mentioned above and select criteria¬†“B” instead of “A” in the formula.

Copyright © 2016 - 2019 | All Rights Reserved