How do I count multiple items in Excel pre-365? For users who are using an earlier version of Excel than Excel 365, you’ll have to work a bit harder for the same results.

To select multiple items in a group in Excel hold Ctrl then select each item in the group. You can also select from multiple groups by holding Ctrl as you click.