B
Blair Macdonald
Hi,
I've got a table that looks like this:
Type Format Size Responses
A 1 5 1 2 3
B 2 4 2 4 7
C 3 3 5 3 8
A 5 4 4 2 1
C 1 4 2 6 7
and I want to create a pivot table for each format, size, and response
that will count each response value based on certain criteria (such as
only counting values greater than 3, or less than 7, etc.) , something
like this:
Format Count (<7)
1 5
2 2
3 2
4 0
5 3
I've tried a few things myself, but I can't seem to get it quite
right. Any help would be appreciated.
Thanks,
I've got a table that looks like this:
Type Format Size Responses
A 1 5 1 2 3
B 2 4 2 4 7
C 3 3 5 3 8
A 5 4 4 2 1
C 1 4 2 6 7
and I want to create a pivot table for each format, size, and response
that will count each response value based on certain criteria (such as
only counting values greater than 3, or less than 7, etc.) , something
like this:
Format Count (<7)
1 5
2 2
3 2
4 0
5 3
I've tried a few things myself, but I can't seem to get it quite
right. Any help would be appreciated.
Thanks,