I am having the worst time trying to wrap my head around this function.
I just can't seem to visualize how to do this. I have a spreadsheet
with the following:

A B C D
1 6 9
2 6 8 8
3 7 3
4 3 5 8


I need to know how many are in A but don't have anything in B. How many
are in C but don't have anything in A or D. Things of this nature but I
just can't seem to find a way of doing it. I am currently using the
functions in this order SUM, COUNTIF, IF but it is returning incorrect
results. Can anyone out there with a better math mind help me to figure
this out.


Thanks so much

Kris