[jdp]

I am trying to create a table from a list of data in Excel. I want to count the number of entries where 1 column meets a certain criteria and another column meets a certain criteria.

For instance:
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.

Thanks,

[Advertisements]

JDP,
I think what you are trying to acheive is to count when a pair of numbers meet a set of conditions

eg. count in the following conditions
a1 = 10 and b1 = 400

but dont count in the following conditions
a1 = 50 and b1 = 400
a1 = 10 and b1 = 550
a1 = 50 and b1 = 550


I couldn't figure out a formula to acheive this directly, but you could create a column with the following formula to see if the pair of numbers match the criteria and then sum or countif the results column.
=IF(A2<41, IF(B2<501,1,0),0)


HTH

Regards
David

[dsm]

JDP,
I think what you are trying to acheive is to count when a pair of numbers meet a set of conditions

eg. count in the following conditions
a1 = 10 and b1 = 400

but dont count in the following conditions
a1 = 50 and b1 = 400
a1 = 10 and b1 = 550
a1 = 50 and b1 = 550


I couldn't figure out a formula to acheive this directly, but you could create a column with the following formula to see if the pair of numbers match the criteria and then sum or countif the results column.
=IF(A2<41, IF(B2<501,1,0),0)


HTH

Regards
David

[dsm]

JDP,
I think what you are trying to acheive is to count when a pair of numbers meet a set of conditions

eg. count in the following conditions
a1 = 10 and b1 = 400

but dont count in the following conditions
a1 = 50 and b1 = 400
a1 = 10 and b1 = 550
a1 = 50 and b1 = 550


I couldn't figure out a formula to acheive this directly, but you could create a column with the following formula to see if the pair of numbers match the criteria and then sum or countif the results column.
=IF(A2<41, IF(B2<501,1,0),0)


HTH

Regards
David