Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I have a sheet with 2 columns. One column the user enters one of three
possible values in the first column. There is a piece of code in the worksheet that based on their selection the second column will have a validation list, relating to what they have entered in column 1. What I want to do is count the number of times each option comes up in column 1. That part is fine, I simply use the COUNTIF command. But one of the possible entries is the word "Other". I only want to count the "Other" entries if it's corresponding entry in column 2 dose not equal "Journey Home" Can this be done? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Count values with conditions - again | Excel Discussion (Misc queries) | |||
How to Search, Count, Match and Post Values | Excel Worksheet Functions | |||
Count data based on past dates | Excel Worksheet Functions | |||
Count Intervals of Filtered TEXT values in Column and Return Count across a Row | Excel Worksheet Functions | |||
If I have X,Y data how do I sum the Y values using a set of bins based on x values | Excel Worksheet Functions |