gnaga
Well-known Member
- Joined
- Jul 9, 2002
- Messages
- 748
- Office Version
- 365
- 2016
- 2013
- Platform
- Windows
Hi All,
I have a two range of cells having an alphabet in each cell (R, M, N, D...)
For ex. Range 1 A10:A41 will have single Alphabet and Range 2 B10:B41 will have single or more than one alphabet (MC, MP,N,R...)
In B9 I need a formula to count number of each unique alphabet in Range 2 for the following condition
Condition
If first cell in Range 1 having R and first cell in Range 2 having any alphabet other than R then take the value as say 12
If Second cell in Range 1 having R and second cell in Range 2 having any alphabet other than R then take the value as say 12 add to the previous 12 and so on until the last cell. Display the final count in B9.
I have a two range of cells having an alphabet in each cell (R, M, N, D...)
For ex. Range 1 A10:A41 will have single Alphabet and Range 2 B10:B41 will have single or more than one alphabet (MC, MP,N,R...)
In B9 I need a formula to count number of each unique alphabet in Range 2 for the following condition
Condition
If first cell in Range 1 having R and first cell in Range 2 having any alphabet other than R then take the value as say 12
If Second cell in Range 1 having R and second cell in Range 2 having any alphabet other than R then take the value as say 12 add to the previous 12 and so on until the last cell. Display the final count in B9.
Book1 | ||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
J | K | L | M | N | O | P | Q | R | S | T | U | |||
6 | ||||||||||||||
7 | R | M | M | D | N | R | R | N | N | R | Range 1 | |||
8 | 32 | M | M | M | D | N | R | M | N | N | C | Range 2 | ||
9 | ||||||||||||||
10 | 12 | 0 | 0 | 0 | 0 | 0 | 12 | 0 | 0 | 8 | ||||
Sheet1 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
J8 | J8 | =SUM(K10:T10) |