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!!!
--
greatday
------------------------------------------------------------------------
greatday's Profile:
http://www.excelforum.com/member.php...o&userid=33158
View this thread:
http://www.excelforum.com/showthread...hreadid=529762