# Measure column - summarization

#### dart73

##### New Member
Hello guys,

I have a matrix with some measure columns that creates some conditions. That´s the Delta_classification.

Now I want to summarize it by category CRITICAL, BAD, REGULAR, ACCEPTABLE, GOOD, EXCELLENT but as this is a measure I"m having trouble to do it. Could you kindly help me on this?!

BR

### Excel Facts

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest
Hi BR and welcome to the Forum

Firstly, sorry about how this looks - the result of dodgy copying & pasting from Excel!!!

Secondly, nesting so many IF functions together to return the appropriate classification is not good practice. A better option is a central lookup table like the following:
 A B C 2 Table Name: tblDeltaClass 3 DL TPH Delta Classification 4 - Excelent 5 0.05 Good 6 0.10 Acceptable 7 0.20 Regular 8 0.30 Bad 9 0.50 Critical Table Name: tblData C15 = VLOOKUP( B15, tblDeltaClass, 2, TRUE ) 14 ID DL TPH Delta 15 0.02 Excelent 16 0.05 Good 17 0.10 Acceptable 18 0.20 Regular 19 0.14 Acceptable 20 0.24 Regular 21 0.34 Bad 22 0.54 Critical 23 0.08 Good 24 0.22 Regular

<tbody>
</tbody>

<tbody>
</tbody>

Now, what do you mean by "summarise it by category"?

To COUNT the number of entries by category, set up another table like this:

 Table Name: tblSummary C30 = COUNTIFS( \$C\$15:\$C\$24, B30 ) 29 Classification Count 30 Excelent 1 31 Good 2 32 Acceptable 2 33 Regular 3 34 Bad 1 35 Critical 1 36 Total 10

<tbody>
</tbody>

Alternatively, if your data has a much greater number of entries, the better option may be to create a Pivot Table where you can choose any one of several measures, or perform full statistical analysis (standard deviations, etc.).

Replies
0
Views
213
Replies
1
Views
214
Replies
0
Views
806
Replies
5
Views
179
Replies
0
Views
297

1,203,242
Messages
6,054,345
Members
444,717
Latest member
melindanegron

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