Vb averaging random fields in Excel 2007 [Closed]

Report
Posts
2
Registration date
Wednesday September 2, 2015
Status
Member
Last seen
September 2, 2015
-
 Blocked Profile -
Thanks very much for help on this . .

After finding a row based on a field value, I need to get the value from a different field in that row . . .I need to repeat this for different rows and then average the desired value into another field. The rows will vary from project to project
Example:

Row 1, AZ1 = "OXII" (yes or no)
If no
Row 2, AZ2 = "OXII" (yes) . . . .AW2 is the first value to be averaged.
Row3, AZ3 = "OXII", no
Row4, AZ4 = "OXII", no
Row5, AZ5 = "OXII", yes. . . .AW5 is the 2nd value to be averaged.

. . .average AW2, AW5 and place value in Row45, AW45

1 reply


The logic syntax of "IF" in Excel is as follows:
=if(logic_test,true,false)

Now apply that and let us know where you need help!

I have said it once, I will say it again. IT!