Alternative criteria selection
 

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