Thank you so much for your response, I may not have explained myself
accurately enough. My results sheet headings are set up as such:

BMI <=18.5-24.9 25-29.9 30+


Weight <=173 174-250 251+

There are other data results that I would like to show up on this page as
well, but we'll just use what I typed above. Each participant has their own
set of results that need to be displayed based on the data entered on the
"data" worksheet.

If I enter that "Miss Jones" has a BMI of 26.7, I would like for this number
to show up under the appropriate heading on the results sheet. I was able to
use the sumproduct formula on another worksheet because I was just trying to
COUNT, but I can't get it to work for this sheet (maybe because the data is a
little bit more complex?

"Gary''s Student" wrote:

This is just an example that you can adapt to your needs. It assumes that
the data is in column A in Sheet1. The data will be transferred to Sheet2 in
columns A thru D.

Sub keniesha()
Dim v As Variant
Set s1 = Sheets("Sheet1")
Set s2 = Sheets("Sheet2")
n1 = s1.Cells(Rows.Count, "A").End(xlUp).Row
For i = 1 To n1
v = s1.Cells(i, "A").Value
Select Case v
Case Is < 20
colum = 1
Case Is < 30
colum = 2
Case Is < 40
colum = 3
Case Else
colum = 4
End Select
roww = s2.Cells(Rows.Count, colum).End(xlUp).Row + 1
s2.Cells(roww, colum) = v
Next
End Sub

So if the data is:

7
3
41
17
17
30
26
17
36
37
4
14
46
17
45
5
13
7
26
41
45
35
45
33
44
21
1
39
19
11
37
44
46
29
23
30
20
25
41
5
25
3
19
29
13
28
48
50
39
19

the result will be:

7 26 30 41
3 26 36 46
17 21 37 45
17 29 35 41
17 23 33 45
4 20 39 45
14 25 37 44
17 25 30 44
5 29 39 46
13 28 41
7 48
1 50
19
11
5
3
19
13
19

--
Gary''s Student - gsnu200789


"Keniesha" wrote:

I have a workbook with several worksheets, one that has the data, and the
other that displays the results (report). I have 4 ranges of data - 0-19.9,
20-29.9, 30-39.9, 40-49.9)

My data sheet shows actual data (ex. 15.9 or 37.2) What kind of formula can
i use to get the actual data to show up under the range that it falls under?
So if someone has a 16.3, it would show up under the appropriate column on
the report page.

I hope this doesn't sound confusing.....I appreciate any help!