Hi I've managed to create a straigt table with some expressions to calculate the columns I need (all good)
I have something like this
| Site | CCS 3 | CCS 4 | Total | Band | Fee |
| 29 | 20 | | | |
| Site 1 | 2 | 1 | 9 | Band B | 100% |
| Site 2 | 0 | 1 | 1 | Band B | 100% |
| Site 3 | 1 | 0 | 4 | Band B | 100% |
| Site 4 | 1 | 1 | 5 | Band B | 100% |
| Site 5 | 1 | 1 | 5 | Band B | 100% |
| Site 6 | 2 | 1 | 9 | Band B | 100% |
| Site 7 | 5 | 0 | 20 | Band C | 110% |
| Site 8 | 3 | 3 | 15 | Band C | 110% |
where the Band is calculated as the following expression
=(Total>150,'Band F',IF(Total>60,'Band E',IF(Total>30,'Band D',IF(Total>10,'Band C',IF(Total>0,'Band B','Band A')))))
How do I know create a separate chart so I can count all the Band Bs and Band Cs
Its probably very simple but I can't seem to figure it out!
Thanks
