H
harteorama
Hi all,
Does anybody know how to do an offset countif, between two words in
vba?
I want to count the number of +1 or -1's, but, there can be varying
amounts of +1's & -1's between these two Words.
The words (apple and orange) are always in Col A, and the 1's are
always in Col C.
Heres what i have in my file....
Col A Col B Col C Col D
APPLE
1
-1
-1
1
ORANGE
This would give me in Cell C1 = Count of number of +1's
Cell D1 = Count of number of -1's
Any pointers would be greatly appreciated..
Many thanks
PJ
Does anybody know how to do an offset countif, between two words in
vba?
I want to count the number of +1 or -1's, but, there can be varying
amounts of +1's & -1's between these two Words.
The words (apple and orange) are always in Col A, and the 1's are
always in Col C.
Heres what i have in my file....
Col A Col B Col C Col D
APPLE
1
-1
-1
1
ORANGE
This would give me in Cell C1 = Count of number of +1's
Cell D1 = Count of number of -1's
Any pointers would be greatly appreciated..
Many thanks
PJ