Hi I have an excel like below
Data is from C to K
I need a formula in A and B to capture the sum of all V1 and V2 respectively. I tried using sumproduct, but i am getting count of V1 and V2 respectively but i need the sum of the V1 next column and V2 next columns respectively.
1 A B C D E F G H I J K
2 V1 V2
3 -- -- 1.5 .75 xyz V1 1.0 abc V1 .5 xyz V2 .75
Can anyone help me out in this regard.
Bookmarks