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 "???"
Many thanks,![]()
Please Login or Register to view this content.
Bookmarks