countif criteria based on a formula

[cboz]

I want to count the number of times the value in cells T251 through AE251 is grater than the value in cell L251*2. The formula below returns Zero when I want it to return 1. The values in T251: AE251 are as follows.

2 32 10 6 8 5 12 9 5 10 7 3

L251*2 = 30 or 15 x 2 = 30

The formula I used is:
=COUNTIF(T251:AE251,">(L251*2)")

Is countif the correct function? I looked up something using sumproduct but I got confused when I learned my arrays would need to have the same dimensions.

 

[AnotherHiggins]

Your syntax is a little off.

Try
[COLOR=blue white]=COUNTIF(T251:AE251,">"&L251*2)[/color]

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ181-2886 before posting.

 

[AnotherHiggins]

By the way, just for future reference this forum is for questions about VBA (macros).

Your question should have been posted in forum68, the Microsoft: Office Forum.

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ181-2886 before posting.

 

[cboz]

Thanks that worked. I don't understand how it works. Why do you need to put the ">" in quotes and add the "&".

Sorry to have asked in the wrong forum. I am usually working on macos when I get stuck and have a question.

 

[AnotherHiggins]

No problem about the forum - it just helps to keep things tidy to place threads in the proper forum.

Basically what you are doing is building a text string after the comma. You start with [!]">"[/!], which is considered text. The [!]&[/!] is used just like when you concatenate two cells[red]*[/red]. Then the [!]Cell Reference[/!] and [!]*2[/!] finish off the string.

[red]*[/red]If you're not familiar, try this:
In A1, type [blue]Hello[/blue]
In A2, type [blue]there[/blue]
In B1, type [blue]=concatenate(A1," ",A2)[/blue]
[tab]observe result

A shorter way to get the same results is:
In B1, type [blue]= A1 & " " & A2[/blue]

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ181-2886 before posting.