using function we can derive the results

try this

=COUNT(IF((A2:A10="cow")*(B2:B10<=90),)) ( use ctrl + shift + enter )

=COUNT(IF((A3:A10="cow")*(B3:B1090),)) ( use ctrl + shift + enter )



On Nov 27, 12:07*pm, "IgorM" wrote:
Hello

I have a table with data as follows

* * * * * * A * * * * * * * * * * B

* * * * * * Animal * * * * * *Age

1 * * * * *Cow * * * * * * * *14

2 * * * * *Sheep * * * * * * *23

3 * * * * *Cow * * * * * * * *87

4 * * * * *Cow * * * * * * * *123

5 * * * * *Sheep * * * * * * *345

6 * * * * *Sheep * * * * * * *22

7 * * * * *Cow * * * * * * * *12

8 * * * * *Sheep * * * * * * *91

It is very simplified of course. I want to have a pivottable and in that
pivottable I want to see how many cows and how many sheeps there are within
a <90 and 90 age band. In other words I want to produce something like
this:

Animal * * * * * *Age < 90 * * * * * * * * * *Age 90

Cow * * * * * * * *3 * * * * * * * * * * * * * * * * 1

Sheep * * * * * * *2 * * * * * * * * * * * * * * * * 2

Total * * * * * * * 5 * * * * * * * * * * * * * * * * 3

Is it possible to do that using calculated field (or other features of
pivottable). I wouldn't like to add any extra columns in the source table to
calculate the age band.

Regards

Igor