Count the number of times two items appear in a table

Originally Posted by ConneXionLost

Hi ResearchRN,

Welcome to the forum!

The result is a single cell:

Please Login or Register  to view this content.

Cheers,

Thanks for the welcome and your reply. However it's not quite what I'm looking for. The query appears to sum the number of times "endoscope" or " surgical microscope" appears in the table. What I need to know is how to find the number of cases in which both an endoscope and a microscope were used in the same case. For example, case number 36 used only an endoscope. Case number 37 used only a microscope. However case numbers 7, 114, and 178 used both. Just scanning the rest of the table it would appear that the total number of cases that used both would be 19 or so.

Just to give you some background, nowadays these cases are done using an endoscope to gain access to the tumor and the microscope to remove it. In the past, they were done mostly by "eyeball". Then the microscope was added, then the endoscope. Now a lot of these cases are done using intra-operative MRI scanning. Lately they've been looking at 3D endoscopes in high def! The question we're trying to answer, among other things, is whether all these technologies really help and if so in what combination. It's the combination part I'm having trouble with.

Thanks very much for your help.

That's perfect! Thanks so much for taking the time to do this. I would never have gotten it on my own.