Using Excel 2007. I am not sure if I am trying to do is too ambitious.

My single column sheet looks something like this
A1
abc
abc, def
abc, ghi
def
def, ghi
abc, def, ghi
ghi

Possible values are abc, def, and ghi in any combination but always in
alpha order

I want to:

Chart the responses on
how many cells have only 'abc',
how many cells have only 'def''
how many cells have only 'ghi',
how many cells have 'abc' & 'def' & 'ghi'
how many cells have 'abc' & 'def'
how many cells have 'abc' & 'ghi'
how many cells have 'def' & 'ghi'


Is this possible without summarizing results first?

Assuming it was not, I tried to summarize the results first and then
chart them, but I am having trouble with the logic. I tried the
following with no luck:

To summarize 'abc' only responses =COUNTIF(A1:A7,isnumber(SEARCH
("abc",A1:A7)))
To summarize 'abc, def'' only responses =COUNTIF(A1:A7,isnumber(SEARCH
("abc, def",A1:A7)+SEARCH("ghi",A1:A7)))
etc



Any suggestions? Thanks in advance.

JL