# Find first cell greater than 0 THEN calculate average and std from that cell to the end

1. ## Find first cell greater than 0 THEN calculate average and std from that cell to the end

I couldn't figure out how to complete this task. I looked around and all the formulas that i have seen only return the value of the that not necessarily the address.

Here is what i'm trying to do
1. Find the first cell with a value higher than "0"
2. Then use that cell address as a starting point for the "average" and "standard deviation" calculations

I have attached a file as to what I would like to do.
Column G should return the address of the first cell with value higher than 0. Then column H and I uses the column G value to calculate.

Thank you so much for all your help!  Register To Reply

2. ## Re: Find first cell greater than 0 THEN calculate average and std from that cell to the en

In row 2

Average
=AVERAGE(INDEX(B2:F2,MATCH(TRUE,INDEX(B2:F2>0,0),0)):F2)

Stdev
=STDEV(INDEX(B2:F2,MATCH(TRUE,INDEX(B2:F2>0,0),0)):F2)  Register To Reply

3. ## Re: Find first cell greater than 0 THEN calculate average and std from that cell to the en

OMFG! That is just freaking awesome! Thank you SO MUCH! you saved so much time for me!  Register To Reply

#### Thread Information

##### Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1