Forum Discussion
I need to count how many times 2 different letters appear in a column & totals in diff. cells
matheteslet me give you a little background. I have been deployed on a special long term assignment involving multiple Agencies for handling an operation for COVID 19. Those agencies send people to be deployed, either during the day and/or people during the night. My boss wants me to include how many people we have deployed from each agency total and how many each agency is sending for the day assignment as well as the night assignment on a weekly staffing report that we are using in onenote as an outline type form which has numerous other items that have to be reported not having to do with staffing. There are 2 of us that are collaborating on the report I handle all the staffing for this assignment he is handling all the operations of this assignment. I am not versed in excel I kind have been thrown into this assignment. What I put together was all I knew on how to use excel. I have been on this assignment since the beginning of March. My boss wants this information for arguments to his boss for justification on the numbers we used for budgetary and training needs. so its not real in depth but so I don't have to count each individual for the day and then count each individual for the night and then go through each sheet and add them all up. The people sign an accountability sheet when they check in and when they check out. The things I need to track is numbers of people as a whole, from each agency, and see any trends of personnel diminishing, which would necessitate me to contact other agencies to be deployed if my numbers diminish. If any of that makes sense. I think in paragraph form I answered everything?
I am completely new to all of this
I wondered if it was Covid related...thank you for doing it! Anyway, I'd be happy to help you design something a bit more robust--our messages passed each other a few minutes ago. Take a look at the first sheet now in what I sent back. I just created a few "dummy day" records...and if you play around with adding new rows at the bottom you'll see two things
I created drop down boxes for three of the four columns...so there's only a need to select an answer, not to type it. The only typing per se is the date, and you can copy it down multiple rows after you've entered the other info from the attendance sheet.
Once you've entered new rows of data, if you go to the Data toolbar, you'll see a place there where you can click on "Refresh All" and the pivot table will automatically update with all the new info.
It's not designed right now to report by week, but that's a simple change. I wanted to get this to you just as a demo of what I was saying a simple but unified database could look like.