mudassiryusuf
New Member
- Joined
- Dec 27, 2016
- Messages
- 3
Hi everyone, thanks for going through my question for helping me out.
I have about 20 rows of data and I need to do a specific count based on 2 criterias
the first criteria , in column A is based on quarters( 1,2,3,4) and the other column B is based on text (TaskA, TaskB, TaskC)
my requirement is to count that in Quarter 1, how many are TaskA, TaskB and TaskC. and similarly for all the 4 quarters.
The other requirement is to do with time frame. Column C has time frame for Tasks that I have. So in Q1, how many days do I have regardless of the kind of task.
For example, if TaskA has 5 days, taskB has 4 days and TaskC has 3 days, and in Q1 I have 3 taskA, and 2 taskB, I need a formula to calculate the total number of days I have been allocated in Q1.
I hope my explanation isn't as confusing as I am right now.
Please let me know if you need any further clarifications.
Thank you
I have about 20 rows of data and I need to do a specific count based on 2 criterias
the first criteria , in column A is based on quarters( 1,2,3,4) and the other column B is based on text (TaskA, TaskB, TaskC)
my requirement is to count that in Quarter 1, how many are TaskA, TaskB and TaskC. and similarly for all the 4 quarters.
The other requirement is to do with time frame. Column C has time frame for Tasks that I have. So in Q1, how many days do I have regardless of the kind of task.
For example, if TaskA has 5 days, taskB has 4 days and TaskC has 3 days, and in Q1 I have 3 taskA, and 2 taskB, I need a formula to calculate the total number of days I have been allocated in Q1.
I hope my explanation isn't as confusing as I am right now.
Please let me know if you need any further clarifications.
Thank you