ExcelBanter - Formula error

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Formula error (https://www.excelbanter.com/excel-discussion-misc-queries/147590-formula-error.html)

Jithu

Formula error

Hi,
While trying to run a macro containing the following code-
Range("N1").Formula = CountIf("K" & x, "J" & z - 1, "yes") / CountIf("L" &
x, "L" & z - 1, "yes")

error appears saying sub ar function not defined
can anyone please help me in this...

Thanks in advance for your posts

jithu

Toppers

Formula error

try:

Range("N1").Formula = "=CountIf(K" & x & ":J" & z - 1 &
",""yes"")/CountIf(L" & x & ":L" & z - 1 & ",""yes"")"

"Jithu" wrote:

Hi,
While trying to run a macro containing the following code-
Range("N1").Formula = CountIf("K" & x, "J" & z - 1, "yes") / CountIf("L" &
x, "L" & z - 1, "yes")

error appears saying sub ar function not defined
can anyone please help me in this...

Thanks in advance for your posts

jithu

All times are GMT +1. The time now is 05:45 PM.