P
Paul_UK
i am trying to count the number of times a number between a range appears in
a column e.g. in sheet 1 i have
column1 Column2
2000 4000
3000 10000
4000 2000
5000 6000
in sheet 2 i have the criteria
A) starts at 1000 and finishes at 1999 B) starts at 2000 and finishes at 3999
C) starts at 4000 and finishes at 10000
in sheet 3 i am trying to summaries sheet 1 data on the sheet 2 criteria
Column 1 Column2
A = 0 0
B = 2 1
C = 2 3
Does anyone know of a count formula i can use to do this
a column e.g. in sheet 1 i have
column1 Column2
2000 4000
3000 10000
4000 2000
5000 6000
in sheet 2 i have the criteria
A) starts at 1000 and finishes at 1999 B) starts at 2000 and finishes at 3999
C) starts at 4000 and finishes at 10000
in sheet 3 i am trying to summaries sheet 1 data on the sheet 2 criteria
Column 1 Column2
A = 0 0
B = 2 1
C = 2 3
Does anyone know of a count formula i can use to do this