How to do the calculation - 29 Nov?
On Sat, 29 Nov 2008 02:18:00 -0800, Eric
wrote:
Does anyone have any suggestions on how to do the calculation?
There is a list of raw data under column A
50, 52, 53, 53, 55, 56
There is a list of numbers under column B
3%, 9%, 5%, 4%, 8%, 8%
I would like to create a matrix to count the frequency
On X-axis, 50, 51, 52, 53, 54, 55, 56
On Y-axis, 0%, 1%, 2%, 3%, 4%, 5%, 6%, 7%, 8%, 9%
Does anyone have any suggestions on how to set the formula to determine the
frequency? For example, 4% & 5& will count 1 for each for the number 53.
Thanks in advance for any suggestions
Eric
Assuming that your "X-axis" is on row 1, from column D to J
and your "Y-axis" is in column C, from row 2 row 11
you cab try the following formula in cell D2
=SUMPRODUCT(($A$1:$A$6=D$1)*($B$1:$B$6=$C2))
Change the 6 to fi the size of your data in column A and B.
Copy the forumula to the entire range D2 to J11 and you matrix is
ready.
Hope this helps / Lars-Åke
|