View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
MartiC MartiC is offline
external usenet poster
 
Posts: 1
Default Total number of occurances for two text values

Here is my sample data:

A B C D
1 Date Name Rec VP
2 2/1 Jane Doe EM F. Charles
3 2/1 Don Duck LJ R. Lee
3 2/2 Minnie Lou SH F. Charles
4 2/2 Angel Wing EM R. Lee
5 2/5 Chris Carol LJ R. Lee
6 2/7 Holly Bugge LJ F. Charles

What I would like to be able to do is input a formula that will be able to
calculate the number of times an value in column C & column D occur (ie: LJ +
R. Lee = 2, LJ + F. Charles = 1).

I am able to get a total of how many times LJ occurs in column C or how many
times R. Lee occurs in column D but not how many times LJ & R. Lee occur at
the same time.

Does this make sense & can anyone help?

Thanks,
Marti