Help please!
I have a list of people attending a function from different departments (e.g. marketing, ticketing, production etc.). I have a drop down box where I can select which department they are attending from. I then have a box where I can enter the number of people attending. I can obviously sum the total attending very easily, but I want my spreadsheet to automatically work out how many from each of the three departments are attending so at the bottom of my spreadsheet I see; total attending, total marketing attending, total ticketing attending, total production attending etc.?
Bookmarks