Skip to main content

【VBA】 Add symbols next to selected cells and show the result of the sum with one click

· One min read
Yan-Ying Liao

Download

Sumif.xlam

Demo

If you don't know how to use xlam file, here's the tutorial.

It's quite often to use Excel Sumif function when we need to sum some specific values, and now you can speed up that work with one click.

There are 4 combinations in the userform, that's adding the symbols to the right or left next to the selected cells and either storing them in Cells or in Textboxes. After you press OK, it'll pop up an input box to let you select where the result would be put. The default symbol is "A", you can customize it by changing the text in the userform.

Noted that when you select the option that symbols are stored in Cells, it'll only sum up that column's value, because I use =Sumif function here, however, there's no limitation when you select the "Textboxes" option, I simply use =Sum to sum values up in this situation.