Apr 21 2021 03:37 AM
Not sure if that title explains it very well! I've tried googling around and using nested IF/Countif functions but I've not had any luck so far.
BACKGROUND:
I have a table, and I use it to create some pie-charts. As far as I could tell, I was unable to make pie-charts from my table directly as it is not numeric, so I created secondary tables (pictured below) with simple 'Countif' functions and made the charts from that numeric data.
This works fine for presenting data for the whole table, however, I also want to produce similar charts for each department.
QUESTION:
I need a formula which essentially filters my original table by the 'College' column, and provides the numeric data for the outcome of how many 'Not applicable/In progress/complete' etc.
So in layman's terms the formula should say IF column C = 'CLES', count if column F = 'Complete'
And I'd repeat that for each department to create charts for each area.
The ultimate goal is to have these charts pulled into a SharePoint page, so it really needs to be fully automated (eg. no manual filtering)
Does that make sense? Is there a way to do this? Or alternatively am I massively overcomplicating the process?
Thank you!
Apr 21 2021 06:05 AM
SolutionApr 21 2021 06:05 AM
Solution