Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Returning Results Based on Two Criteria | Excel Worksheet Functions | |||
Cell Selection after "Enter" | Excel Discussion (Misc queries) | |||
sorting more than 3 keys | Excel Discussion (Misc queries) | |||
SUMPRODUCT Formula to Count Row of data Below Matched Criteria | Excel Worksheet Functions | |||
Wildcard Selection Criteria | Excel Discussion (Misc queries) |