count frequency of two values in same row

G

Guest

I need to calculate the type of documents open, working and approved.

Type of document (Col - A) Status
A Open
B Working
C Open
D Open
E Approved
F Working

What formula should I use to get the total number of documents in "open",
approved and working status.
Can someone please help me
 

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

Math help 3
Count multiple cells against multiple criteria in an Excel spreads 7
adding figures that match 2 true and 1 false if statement conditio 5
Sum range if 2 conditions are met 5
Count values only if matches and return on another worksheet 3
Conditional count of rows dependent on multiple columns 1
match/index using multiple values 5
Counting the # of values in a range ??? 8

Top