I am relatively new to pivot tables, and there is one thing that I just can't figure out how to do.

I have a worksheet that has several columns of categorical data. Each column (Groups 1, 2, 3) has the same type of categorical data, i.e. each cell is filled with one of these four values:

```
"0"
"001 to 025"
"026 to 050"
"051 to 075"
```

Below is the current format of my data, followed by how I would like my data to be formatted in a pivot table. The pivot table would count the occurrences of each of the four possible values within each group column, and return them in the table.

```
Current Format of Data:
Group 1 Group 2 Group 3
Record 1 001 to 025 001 to 025 051 to 075
Record 2 026 to 050 001 to 025 0
Record 3 051 to 075 001 to 025 051 to 075
How I would like my pivot table to look:
Group 1 Group 2 Group 3
0 0 0 1
001 to 025 1 3 0
026 to 050 1 0 0
051 to 075 1 0 2
```

So far I have not been able to figure out how to do this. I can create a pivot table such that one of the three groups can be displayed (i.e. chart has two columns, one is the row labels, and one is the count values for only one of the groups), but not all three at the same time.

Is what I am trying to do possible? If so, could someone tell me how to do it?

Thanks, Liza

Additional info:

Here is a link to a google web album of pics of my data with captions explaining what I would like to do:

https://picasaweb.google.com/105380569660384078356/20130823?authuser=0&feat=directlink

`COUNTIFS`

instead of pivottable, since the pivottable doesn't know about the class widths, right? Can you perhaps give a snapshot of your current data table? – Jerry Aug 22 '13 at 18:43`=COUNTIF(interval;NOT(ISERROR(OR(MATCH($col row;first col of data;0);MATCH($col row;second col of data;0);MATCH($col row;third col of data;0)))))`

– Doktoro Reichard Aug 23 '13 at 10:40