A brief introduction to my problem. My data is organized as follows

Type S1 S2 S3 …
A c c i
B i c i
B c c c
A
C
...


Using DCOUNTA works like a charm finding the number of occurrences of “c” within “S#” of type “A”. However, I want to do the following:

S1 S2 S3
A
B
C

where the entries are the occurrences of “c”. Can I do this without setting up a table for criteria i.e. can I replace the criteria in DCOUNTA(data,”S1”,A1:B:2)?

I hope there is some help!! Setting up all these side tables would be a nightmare!!

Thanks for any help!!!