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