Looping through rows and manipulating references

Hi,

Could someone help me with the following query please?

If I have a column with data of the following:
A1 : 0
B1 : 0
C1 : 0
V1 : 1

A2 : 1
B2 : 0
C2 : 0
V2 : 1

A3 : 1
B3 : 0
C3 : 0
V3 : 0

And I want to sum the values of Vx where Ax > 0. How would I do this? The above example would result in 1 (V2 + V3) because A2 and A3 > 0.

I've been trying to modify:
http://www.excelforum.com/excel-work...-a-column.html

However, I cannot find how to convert a result into a cell reference i.e. what to put at "???"

{
=SUM(
  IF(
    AND(
      Z1:Zn > 0, 
      MOD(ROW(Y:Z)-1,4)=0
    ),
    ???,
    0
  )
)
}

Many thanks,

Ah I see thanks. So I'd have to put the data in multiple columns so Vx was next to Ax.

In the end I created a macro to just alert the values and manually filled them in (ouch, but done). If anyone is interested it is below. Ugly hard coding and magic numbers, but just needed something quick.

Sub foo()
  Dim iValue As Integer
  Dim retVal As Integer
  Dim offset As Integer
  
  ' Every 8th row starting at (E.g. A is row 2, B is row 3)
  offset = 2
  
  Dim d As String
  
  For i = 1 To 481
    iValue = 0
    ' Check if Dom 5 Value
    If ((i - offset) Mod 8) = 0 Then
        ' Data is all in Column K
        iValue = Range("K" & i)
        If iValue > 0 Then
            ' 9 because every 8th row. -offset because as the row increases the 
            ' distance to row V decreases
            retVal = retVal + Range("K" & i + (9 - offset))
        End If
    End If
  Next i
  
  MsgBox (retVal)
End Sub