FREQUENCY FORMULA
 

I have this formula in Excel 2003.
=MAX(FREQUENCY(IF(AM$67:AM$2001=AN4,ROW(AM$67:AM$2 001)),IF(AM$67:AM$2001<AN4,ROW(AM$67:AM$2001))))
I am trying to calculate the number of runs located in column AM. Cell AN4 equals the number 2 that I am trying to figure out occurred so many times as part of a run not the number of times it occurred using COUNTIF. I used a formula I found online that worked for them perfectly. Won't work for me. I get #VALUE! instead. What am I doing wrong? Thanks.

FREQUENCY FORMULA
 

Hi,

Am Fri, 6 Nov 2015 23:03:59 -0800 (PST) schrieb rhhince:

I have this formula in Excel 2003.
=MAX(FREQUENCY(IF(AM$67:AM$2001=AN4,ROW(AM$67:AM$2 001)),IF(AM$67:AM$2001<AN4,ROW(AM$67:AM$2001))))
I am trying to calculate the number of runs located in column AM. Cell AN4 equals the number 2 that I am trying to figure out occurred so many times as part of a run not the number of times it occurred using COUNTIF. I used a formula I found online that worked for them perfectly. Won't work for me. I get #VALUE! instead. What am I doing wrong? Thanks.

try:

=COUNTIF(AM$67:AM$2001,AN4)

Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional

FREQUENCY FORMULA
 

On Saturday, 7 November 2015 04:17:42 UTC-6, Claus Busch wrote:
Hi,

Am Fri, 6 Nov 2015 23:03:59 -0800 (PST) schrieb rhhince:

I have this formula in Excel 2003.
=MAX(FREQUENCY(IF(AM$67:AM$2001=AN4,ROW(AM$67:AM$2 001)),IF(AM$67:AM$2001<AN4,ROW(AM$67:AM$2001))))
I am trying to calculate the number of runs located in column AM. Cell AN4 equals the number 2 that I am trying to figure out occurred so many times as part of a run not the number of times it occurred using COUNTIF. I used a formula I found online that worked for them perfectly. Won't work for me. I get #VALUE! instead. What am I doing wrong? Thanks.

try:

=COUNTIF(AM$67:AM$2001,AN4)

Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional

Thanks. I will do that.

Địa chỉ bán buôn , bán lẻ đàn Piano giá rẻ nhất thị trường:



http://gia-piano-abm.blogspot.com/20...m-music_0.html

http://gia-piano-abm.blogspot.com/20...ban-piano.html

http://gia-piano-abm.blogspot.com/20...dan-piano.html

http://gia-piano-abm.blogspot.com/20...-piano_30.html

http://gia-piano-abm.blogspot.com/20...dan-piano.html

http://gia-piano-abm.blogspot.com/20...dan-piano.html

http://gia-piano-abm.blogspot.com/20...mua-piano.html

http://gia-piano-abm.blogspot.com/20...-piano_30.html

http://gia-piano-abm.blogspot.com/20...no-gia-re.html

http://gia-piano-abm.blogspot.com/20...-piano-cu.html

http://gia-piano-abm.blogspot.com/20...gia-piano.html