# countif issues

#### mudassiryusuf

##### New Member
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

### Excel Facts

Copy formula down without changing references
If you have =SUM(F2:F49) in F50; type Alt+' in F51 to copy =SUM(F2:F49) to F51, leaving the formula in edit mode. Change SUM to COUNT.

#### mudassiryusuf

##### New Member
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

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

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

I am able to respond in real time until it resolved

#### mudassiryusuf

##### New Member
Thank you seekerarcane.
That's exactly what I did !!

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

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

I am able to respond in real time until it resolved

Replies
6
Views
564
Replies
6
Views
547
Replies
3
Views
453
Replies
5
Views
668
Replies
4
Views
463

1,195,670
Messages
6,011,074
Members
441,581
Latest member
rp4717

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back