How to do the calculation - 29 Nov?
Hi,
Set up your matrix like this where 50 is in D1 and 1% is in C2, then the
formula in D2 is
=COUNTIFS($A$1:$A$6,D$1,$B$1:$B$6,$C2) (in 2007)
or
=SUMPRODUCT(--($A$1:$A$6=D$1),--($B$1:$B$6=$C2)) (in 2003)
50 51 52 ....
1% 0 0 0
2% 0 0 0
3% 1 0 0
4% 0 0 0
....
If this helps, please click the Yes button
Cheers,
Shane Devensire
"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
|