View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sonia S Sonia S is offline
external usenet poster
 
Posts: 1
Default 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