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!!!
Bookmarks