JCARMICHAEL
New Member
- Joined
- Jan 2, 2004
- Messages
- 3
I need help with a formula for counting how many occurrences exist in 2 seperate columns. For instance in my spreadsheet in the Column Heading i have a Column for "New/Renewal" (designated by an "N" or an "R"). I also have a seperate column for "Successful/Unsuccessful" which is designated by entering a "S" or a "U".
What i need is a formula that counts how many times times, for instance, both "N" and "S" occur.
Does that make sense? Please help.
What i need is a formula that counts how many times times, for instance, both "N" and "S" occur.
Does that make sense? Please help.