| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula to count occurence between two rows
Can anyone help with this formula problem.
I'm working on a large workbook and in row D18:KK18 I have a series of eight different values (i.e. SLS, SLM, MLS, MLM, AH, FH, MS, EV). In row D17:KK17 I have the number of occurence of these values. Is there a CountIf (or other) formula I can use that will recognise the occurences of each value in row 18 and sum the number of occurences in row 17? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to count occurence of multiple characters in a cell | Excel Worksheet Functions | |||
| count occurence and present results | Excel Worksheet Functions | |||
| Using Sumproduct to count text occurence | Excel Worksheet Functions | |||
| Count the occurence of more than one condition | Excel Worksheet Functions | |||
| formula to count occurence of criteria in 2 columns | Excel Worksheet Functions | |||
Threaded Mode
