Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I would like to count the # of times a value occurs in Col B base
I have 2 colums - satisfaction rating (Col A), and importance rating (Col B)
I would like to count the # of times a value occurs in Col B based on its related value in Col A That is, for example, count the number of occurences of a high importance, but low satisfaction. Can anyone help? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I would like to count the # of times a value occurs in Col B base
Same formula as in your previous question, but let's not hard code the
variables. Designate particular cells to contain the criteria, so that you can easily change them without having to revise the formula itself. Previous formula: =SUMPRODUCT((A1:A100="High")*(B1:B100="High")) So, let's say you use C1 for the Column A criteria, and C2 for the Column B criteria: =SUMPRODUCT((A1:A100=C1)*(B1:B100=C2)) -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "shopaholic" wrote in message ... I have 2 colums - satisfaction rating (Col A), and importance rating (Col B) I would like to count the # of times a value occurs in Col B based on its related value in Col A That is, for example, count the number of occurences of a high importance, but low satisfaction. Can anyone help? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I would like to count the # of times a value occurs in Col B b
Thanks so much. Thats perfect!
"RagDyer" wrote: Same formula as in your previous question, but let's not hard code the variables. Designate particular cells to contain the criteria, so that you can easily change them without having to revise the formula itself. Previous formula: =SUMPRODUCT((A1:A100="High")*(B1:B100="High")) So, let's say you use C1 for the Column A criteria, and C2 for the Column B criteria: =SUMPRODUCT((A1:A100=C1)*(B1:B100=C2)) -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "shopaholic" wrote in message ... I have 2 colums - satisfaction rating (Col A), and importance rating (Col B) I would like to count the # of times a value occurs in Col B based on its related value in Col A That is, for example, count the number of occurences of a high importance, but low satisfaction. Can anyone help? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I would like to count the # of times a value occurs in Col B b
You're welcome.
Thanks for the feed-back. -- Regards, RD ---------------------------------------------------------------------------- ------------------- Please keep all correspondence within the Group, so all may benefit ! ---------------------------------------------------------------------------- ------------------- "shopaholic" wrote in message ... Thanks so much. Thats perfect! "RagDyer" wrote: Same formula as in your previous question, but let's not hard code the variables. Designate particular cells to contain the criteria, so that you can easily change them without having to revise the formula itself. Previous formula: =SUMPRODUCT((A1:A100="High")*(B1:B100="High")) So, let's say you use C1 for the Column A criteria, and C2 for the Column B criteria: =SUMPRODUCT((A1:A100=C1)*(B1:B100=C2)) -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "shopaholic" wrote in message ... I have 2 colums - satisfaction rating (Col A), and importance rating (Col B) I would like to count the # of times a value occurs in Col B based on its related value in Col A That is, for example, count the number of occurences of a high importance, but low satisfaction. Can anyone help? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I count the number of times text in column A matches text i | Excel Worksheet Functions | |||
How to count the number of times something occurs within a certain month | Excel Worksheet Functions | |||
How to count the number of times something occurs within a certain month | Excel Worksheet Functions | |||
how do i count how many people are working between two times in e | Excel Worksheet Functions | |||
How do I count the times a number occurs in a given criteria? | Excel Discussion (Misc queries) |