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,