| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
COUNT IF + using 2 sets of data
A B C
1 BB 6 2 BB 3 a 5 4 a 5 5 BB 5 ok, still a beginner so i need simple answers. what i want to do is count the number of non blank entrys in colum C based on only those that are labled BB in B. I feel like this should be very simple COUNT option similar to SUMIF(B1:B5,"BB",C1:C5) |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
COUNT IF + using 2 sets of data
Maybe,
=SUMPRODUCT((B1:B5="BB")*(C1:C5<"")) Mike " wrote: A B C 1 BB 6 2 BB 3 a 5 4 a 5 5 BB 5 ok, still a beginner so i need simple answers. what i want to do is count the number of non blank entrys in colum C based on only those that are labled BB in B. I feel like this should be very simple COUNT option similar to SUMIF(B1:B5,"BB",C1:C5) |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
COUNT IF + using 2 sets of data
yes great !! thank you very much!!! |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
COUNT IF + using 2 sets of data
=sumproduct((left(B1:B5,2)="BB")*(C1:C50))
wrote in message oups.com... A B C 1 BB 6 2 BB 3 a 5 4 a 5 5 BB 5 ok, still a beginner so i need simple answers. what i want to do is count the number of non blank entrys in colum C based on only those that are labled BB in B. I feel like this should be very simple COUNT option similar to SUMIF(B1:B5,"BB",C1:C5) |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
COUNT IF + using 2 sets of data
Make that:
=sumproduct((left(B1:B5,2)="BB")*((C1:C5<""))) "Jim May" wrote in message ... =sumproduct((left(B1:B5,2)="BB")*(C1:C50)) wrote in message oups.com... A B C 1 BB 6 2 BB 3 a 5 4 a 5 5 BB 5 ok, still a beginner so i need simple answers. what i want to do is count the number of non blank entrys in colum C based on only those that are labled BB in B. I feel like this should be very simple COUNT option similar to SUMIF(B1:B5,"BB",C1:C5) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I count sets of cells in two columns? | Excel Worksheet Functions | |||
| Excel graph 3 sets of data. 2 sets as lines 1 as column? | Charts and Charting in Excel | |||
| count cells with year sets in a column? | New Users to Excel | |||
| How to count sets of numbers | Charts and Charting in Excel | |||
| Count rows that match 3 sets of criteria? | Excel Worksheet Functions | |||
Hybrid Mode
