CODEWITHSUNDEEP
excel
Srinivas Erukulla
Srinivas Erukulla

Reputation: 81

How to Count link with two columns text Result

This is Table
What i want
Srinivas How many Removed Count
Srinivas How many Created Count

enter image description here


No I Need Result

enter image description here

Upvotes: 0

Views: 32

Answers (3)

Mrig
Mrig

Reputation: 11702

Enter the below formula in Cell E2

=COUNTIFS($B$2:$B$17,$D2,$A$2:$A$17,E$1)

Drag/Copy down and across (to right) as required.

For total use

=SUM(E2:E4)

and drag across to right. See image for reference.

enter image description here

Upvotes: 1

teylyn
teylyn

Reputation: 35915

Use a pivot table. That's what they are made for. No formulas needed for that.

I suggest you turn the data into an Excel Table object first, by clicking any cell in the data and then Insert > Table and tick the box for "My table has headers".

Next, click a cell in the newly created table, then click Insert > Pivot Table. Drag "Study Director" into the rows box, "Folder Status" into the Columns box and again into the Values box.

When your source data changes, you only need to refresh the pivot table.

The benefit of this approach is that you don't run the risk of missing to add a new name in the data source to your formula setup.

enter image description here

Upvotes: 2

Chef1075
Chef1075

Reputation: 2724

=COUNTIFS(RANGE1, THING_IN_RANGE1, RANGE2, THING_IN_RANGE2)

Put this is the cells you need to count.

Upvotes: 3

Related Questions