Forum Discussion
How to tally number of audits?
CRick1997 Not convinced that the way you collect your data is the most effective, but from judging the screenshot you should be able to use SUMIF.
Personally, I would collect all data in a single table (date, employee, #audits,#reports, etc. ) and create summaries from that table. Per day, per employee, whatever, for example, by using a pivot table.
The attached file contains a mock-up of your schedule with a summary using SUMIF. From column L and onwards, I demonstrated the use of a single structured table, summarising it using a pivot table. You say you are new to Excel, so it may be a bit overwhelming to begin with. But I believe it's better to learn some of the basic features first and do thing right from the start.
CRick1997 Not convinced that the way you collect your data is the most effective, but from judging the screenshot you should be able to use SUMIF.
Personally, I would collect all data in a single table (date, employee, #audits,#reports, etc. ) and create summaries from that table. Per day, per employee, whatever, for example, by using a pivot table.
The attached file contains a mock-up of your schedule with a summary using SUMIF. From column L and onwards, I demonstrated the use of a single structured table, summarising it using a pivot table. You say you are new to Excel, so it may be a bit overwhelming to begin with. But I believe it's better to learn some of the basic features first and do thing right from the start.
Riny_van_Eekelen Thank you! This actually helped me a lot! I see why you said my chart wasn't the best for this task, so I changed it up a little bit so that I can just input the entire column into the function.
-C
