count number of times when column A <="10" and Column B<="10" also

S

Shup0739

okay i need some major help I cannot figure the easiest way to do this
without going crazy! so any help would be greatly appreciated.

I have 1881 line items in two columns they are "Length" and "Width" values
and I want to count the number of "lenghts" and "widths" that are less than
or equal to the value 10 but greater than the value 5 ! in other words I
would like to create a table very similar to a multiplcation table with
"length" vertically, and "width" horizontally, and then count the number of
occourances where they both fall between values of 0-100 in incriments of 5.
Does anyone out there have a clue as to the best or easiest approach in doing
this ?

Regrads,
Shup
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need to count no. of rows where cell in column A = "value1" AND cellin column B (same row) = "value2 2
Count entries in the column translating to minutes. 5
Subtotal - SUM, COUNT NUMBER, 'Live' Formula 5
number times a value appears in a column beside it chronological 3
VBA group the number in the Column and Copy to the new worksheet. 0
Count number of childre between ages 0-5,6-10, 11-15 4
Counting values in column B in condition of A 2
How do I use "column" function to get the column number of the firstcell matching criteria? 1

Top