Hi all, I have a question related to a COUNTIFS formula I'm trying to define - I have a Gantt Chart that I use for planning and analysing workload, and I'd like to plot some figures related to efficiency. I'd like to be able to plot P.V.A against Assigned Person by Month (based on the START DATE column). My initial plan was to use COUNTIFS to do this but I'm having trouble getting the formula to include the month in it's current format - any advice? Sorry about the screenshot, work PC won't let me use L2BB. Thanks!
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
COUNTIFS Question
- Thread starter ChaosPup
- Start date
6StringJazzer
Well-known Member
- Joined
- Jan 27, 2010
- Messages
- 3,658
- Office Version
- 365
- Platform
- Windows
- Mobile
Where are you getting Actual Days from and how are you applying the red fill color for the overrun?
Also I've never heard of the acronym "PVA". I would call this Schedule Variance.
Also I've never heard of the acronym "PVA". I would call this Schedule Variance.
Upvote
0
BigBeachBananas
Active Member
- Joined
- Jul 13, 2021
- Messages
- 450
- Office Version
- 365
- Platform
- Windows
- MacOS
PVA = Plan vs. Actual
Upvote
0
Similar threads
- Question
- Question
