Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
count values in one column based on their realtionship with anoth.
I have 2 columns of data, one column contains a rating on the level of
importance, and the other a rating of the level of satisfaction. I need a function that will allow me to count the number of occurences of a record where the level of imporance is high and the level of satisfaction is high, etc. So, count only the instances of high satisfaction if the importance is also listed as high in the column next to it. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
count values in one column based on their realtionship with anoth.
Try this:
=SUMPRODUCT((A1:A100="High")*(B1:B100="High")) -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "shopaholic" wrote in message ... I have 2 columns of data, one column contains a rating on the level of importance, and the other a rating of the level of satisfaction. I need a function that will allow me to count the number of occurences of a record where the level of imporance is high and the level of satisfaction is high, etc. So, count only the instances of high satisfaction if the importance is also listed as high in the column next to it. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lookup values in one column to return another | Excel Worksheet Functions | |||
Column A = X, Column B =y count = count +1 | Excel Worksheet Functions | |||
Resetting values based on change in cells of other column | Excel Discussion (Misc queries) | |||
Count cells based on date range in another column | New Users to Excel | |||
Count based on another column | Excel Discussion (Misc queries) |