Formula For TA Report

[rajmeena06]

Dear all,

I want 2 know the excel formula for below mentioned Problem.

As the formula should show the value upto it taking including zero.
As in attached pic ,the result should be TA 4.

[dacoder]

Dear all,

I want 2 know the excel formula for below mentioned Problem.

As the formula should show the value upto it taking including zero.
As in attached pic ,the result should be TA 4.

Please explain what you are trying to do. Its unclear from what you have written.

[maahsan]

If you want to sum all the samples from TA=0 to TA=4 and so on then you can just use the sum function.

[rajmeena06]

Hi,
see if want to analyze TA Report,From Match(Max) formula i can get the maximum sample of TA From Mobile is Taking.Ok

But I want to nw the formula through which upto row mobile is taking sample in TA Report.
Means Ex:-TA0(100 Sample);TA1(1000);TA2(400);TA3(0);TA4(7000);TA6(0);TA7(780);TA8(900);TA(100).
formula result show me in above sample it is Taking Sample Upto Numeric TA9.sO,result should show be TA9.Hope you understand.

[Rooster[BG]]

If I understood you correctly, you need some cumulative statistics starting from TA0 to max TA sample available. Is this correct ?

One way is to count all samples for each value category (in our case TA)

Example (values are for each category)
TA0 - 10
TA1 - 5
TA2 - 7
TA3 - 2....

No up to :
TA0 - 10
TA1 = TA0 Samples + T1 Samples - 15
TA2= sum(TA0 to TA2) - 22
....

The other way is to count values that are less than specific value

Example (values are for each category)
TA0 - 50
TA1 - 12
TA2 - 7
TA3 - 30...

Up to:
TA0 = count (<=TA0) ( Equal sign depends of your needs) - 50
TA1 = count (<=TA1) - 62
TA2 = count (<=TA2) - 69
....

I hope this helps. If I'm mistaken and this is not what you are looking for, please more explanations.

BR,
Rooster[bg]

[fdeniz]

Thank you wery much

[rajmeena06]

Thaks for Trying but this is not i want dear.

See,In TA Report what we want to know

1.Max MRs taking from which distance...for this i have formula.ok

2.) second thing upto (Numeric value are coming,Wheter the count is so small eg..10 only ) Mrs are coming (TA).For this i want to know the formula.
Ex:-
Ta0:-1000 sample ok
Ta1:-0
Ta2:-2000
Ta3:-0
Ta4:-0
Ta5:-70
Is small example now Resultant formula should show that its Taking MRs from Ta5 also.Hope you understand my issue.