Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count a Match set of values between cells
I want to produce a page within my workbook for results from my work page.
On my work page and have two columns F and G which down the page will have an array of entries in each. I want to count the number of occurances where something in column F and something in column G are equal to two different values. This is my example. F G TYPE GLAZING 5 S SG-3 6 C 7 S SG-3 8 C 9 S SG-3 For my results I want to know how many times that "S" and "SG-3" occur side by side in the same row as shown above. Can someone please enlighten me how to accomplish this task? Thank you, John M. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do i count cells with values in a certain range ? | Excel Discussion (Misc queries) | |||
How to Search, Count, Match and Post Values | Excel Worksheet Functions | |||
Count cells with values x and <y | Excel Discussion (Misc queries) | |||
How do I count cells with non zero values? | Excel Discussion (Misc queries) | |||
Count cells with specific values in the cells next to them? | Excel Worksheet Functions |