Thanks a lot for your solution. I got it..
Regards,
Vinu.
On Apr 24, 9:28 pm, Harsh Gharpure wrote:
> For the data range you have specified, following is the solution:
>
> A B C (formula)
>
> 25 0 -100 2 -> = countif(a1:a7,">0") -
For the data range you have specified, following is the solution:
A B C (formula)
25 0 -1002->= countif(a1:a7,">0") -
countif(a1:a7,">100")
150101 -200 1 -->= countif(a1:a7,">100") -
countif(a1:a7,">20
Hello
Here is your solution.
Chandra Gupta
On Sat, Apr 24, 2010 at 3:03 AM, vinu wrote:
> Hello Frnds,
>
> I have a data like this: columnA -Data & column B- range & column c-
> Data in Range(Need formula for this), Please help me a formula to get
> the answer in column C.
>
> A
Hello Frnds,
I have a data like this: columnA -Data & column B- range & column c-
Data in Range(Need formula for this), Please help me a formula to get
the answer in column C.
A B C
25 0 -100 2 ( Need a formula to count the col A data
which appears in B Co
