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 "???"

Please Login or Register  to view this content.

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.

Please Login or Register  to view this content.