countif issues

[mudassiryusuf]

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

 

[mudassiryusuf]

Hey guys,
I solved it using the older posts on this awesome website.

I used COUNTIFS and SUMIF formulas.

Worked wonders.

Thanks a lot anyways

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

 

[seekerarcane]

In order to calculate total number of tasks, Like Task A, you will use COUNTIFS() function


=COUNTIFS($B$3:$B$12,"=Task A",$A$3:$A$12,"=1")

and Likewise for other tasks and quarters.


and to calculate total number of days for tasks, like Task A in quarter 1, you will use SUMIFS() function

=SUMIFS(C3:C12,B3:B12,"=Task A",A3:A12,"=1")


I am able to respond in real time until it resolved

 

[mudassiryusuf]

Thank you seekerarcane.
That's exactly what I did !!
Appreciate your help !!

In order to calculate total number of tasks, Like Task A, you will use COUNTIFS() function


=COUNTIFS($B$3:$B$12,"=Task A",$A$3:$A$12,"=1")

and Likewise for other tasks and quarters.


and to calculate total number of days for tasks, like Task A in quarter 1, you will use SUMIFS() function

=SUMIFS(C3:C12,B3:B12,"=Task A",A3:A12,"=1")


I am able to respond in real time until it resolved