Good evening,
First post here from a moderate Excel user in need of assistance please, I am trying to create a project burn down chart against specific project manager names. Using the sample data table I have attached I want to insert a COUNTIFS formula in cells F3 to I10 of the chart table that:
I can write the formulas required to return values for bullets one and two as below, but have struggled with a formula for column three or joining them all up into one. Any help appreciated.
Many thanks,
Leo
First post here from a moderate Excel user in need of assistance please, I am trying to create a project burn down chart against specific project manager names. Using the sample data table I have attached I want to insert a COUNTIFS formula in cells F3 to I10 of the chart table that:
- counts the number of projects against a specific name in column A;
- then counts how many of those projects fall in a calendar month set out in column B;
- where there is no date in column B and its blank I need to then count the date from column C instead.
-
Many thanks,
Leo