ExcelBanter - count frequency of two values in same row

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - count frequency of two values in same row (https://www.excelbanter.com/excel-worksheet-functions/139724-count-frequency-two-values-same-row.html)

Sonia S

count frequency of two values in same row

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

Himani[_2_]

count frequency of two values in same row

=Countif(B2:B7,"Open")
"Sonia S" wrote:

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

All times are GMT +1. The time now is 07:01 AM.