Hi Guys,(and gals)
Am tearing my hair out the little i have left, im looking for a function that seemed simple at first, i have a table (A:D), in column "A" there is a name and coloumn "D" a 1 or 0, i need a function to do a v lookup on an coloumn and then count all the ones that are assosiated with that name,
my effort was
there are a number of other names in "A" and only 1's and 0's in "D" but not all names have a 1 its sort of like
-A------B-----C------D
TSTL----x-----x------1
PRAX----x-----x------1
TSTL----x-----x------0
PAS-----x-----x------0
TSTL----x-----x------1
so this would be 2
i would add a better example but cant appologies
Many thanks in advance will keep trying till im bauld!
Bookmarks