Summing the counts from more than one column

[MadScientist96]

Hi,
I'm kinda new to Excel pivot charts and I have a small problem with how to manipulate pivot chart data.

I deal with patient data and test information extracted from a LIM system and what I need to do is to count the number of times a particular test was performed, from multiple columns, for a given month for each specimen type. Patients often have multiple tests, but depending on the test code, it is ordered and therefore put into various columns as a result, over which I have no control. The data I want to count is therefore present in one of two or more columns but never more than one for each patient in the data spreadsheet.

The data displayed in the spreadsheet might look somewhat like this below:

Month Received Patient details Specimen Test 1 Test 2
Jan Name 1 blood A B
Jan Name 2 blood B (blank)
Jan Name 3 Bone Marrow A B
Feb Name 4 blood A B
Feb Name 5 Bone Marrow B (blank)
Feb Name 6 blood A B



In a pivot table, how do I set it up so that I get the information, from this example, that tells me that test B was done 2 times in January and 2 times in February for blood and once each for Jan and Feb for bone marrow??
Any help appreciated.
cheers
MadScientist

[MadScientist96]

Apologies, I meant to say, Pivot tables...not charts. The formatting wasn't kept for the mock data I provided too. sorry