Countif column a1:a100<=40 and column b1:100<=500
then there will be columns where I want it to count entries between certain numbers
Countif column a1:100>40 but <100 and column b1:b100>1000 but <5000
Each countif statement would be a block in the chart.
So far I am not having much luck.