| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
counting information in one column based on criteria in another co
Have a list of states in one column and I want to count how many times a
value appears in another column. My example is this I have a range of numbers in column c from 1 to 10. Based on the value in column a (state abbrv) I need to count the number of times the number 6 appears. |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
counting information in one column based on criteria in another co
Try something like this...
To count for state New York and 6: =SUMPRODUCT(--(A1:A100="NY"),--(C1:C100=6)) -- Biff Microsoft Excel MVP "lost in excel" <lost in wrote in message ... Have a list of states in one column and I want to count how many times a value appears in another column. My example is this I have a range of numbers in column c from 1 to 10. Based on the value in column a (state abbrv) I need to count the number of times the number 6 appears. |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
counting information in one column based on criteria in anothe
It worked like a charm! Thanks for the help!
"T. Valko" wrote: Try something like this... To count for state New York and 6: =SUMPRODUCT(--(A1:A100="NY"),--(C1:C100=6)) -- Biff Microsoft Excel MVP "lost in excel" <lost in wrote in message ... Have a list of states in one column and I want to count how many times a value appears in another column. My example is this I have a range of numbers in column c from 1 to 10. Based on the value in column a (state abbrv) I need to count the number of times the number 6 appears. . |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
counting information in one column based on criteria in anothe
You're welcome. Thanks for the feedback!
-- Biff Microsoft Excel MVP "lost in excel" wrote in message ... It worked like a charm! Thanks for the help! "T. Valko" wrote: Try something like this... To count for state New York and 6: =SUMPRODUCT(--(A1:A100="NY"),--(C1:C100=6)) -- Biff Microsoft Excel MVP "lost in excel" <lost in wrote in message ... Have a list of states in one column and I want to count how many times a value appears in another column. My example is this I have a range of numbers in column c from 1 to 10. Based on the value in column a (state abbrv) I need to count the number of times the number 6 appears. . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Summing/Counting Data in One Column Based on Criteria Another Col | Excel Worksheet Functions | |||
| Counting items in one column based on criteria in another column | Excel Worksheet Functions | |||
| Counting items in one column based on criteria in another | Excel Worksheet Functions | |||
| Sum column information based on multiple criteria | Excel Worksheet Functions | |||
| Counting & Summing based on criteria on another column | Excel Discussion (Misc queries) | |||
Linear Mode
