Counting Worksheet Data

B

Ben Lott

I am using Excel 2003.

I created an excel worksheet with 6 questions that we use to audit charts.
There are 3 options for each question using drop down option; complete,
incomplete, and N/A. I would like to know if it is possible to have excel
count how many completes, inompletes, and N/As so I can calculate compliance
statistics. Below is a small sample of my worksheet:

MR NUMBER VERIFICATION TOTAL TRANSFUSION REACTION
XXXXXX Complete Complete Complete
XXXXXX Complete Complete Complete
XXXXXX Complete Incomplete Incomplete
XXXXXX Complete Complete Complete
XXXXXX Complete N/A N/A
XXXXXX Complete N/A N/A
Complete
Incomplete
N/A
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Drop down menu formatting 2
SUMPRODUCT with date range running slow 1
Help? I need help in making formulas work to accomplish... 0
Need a little math help in making a formula 2
Counting something 5
Dynamic Updates on Compiled Worksheet 0
Count partial dates 1
Calculate the total overlapping time of multiple tasks, excluding non-working times 1

Top