| Home |
| Search |
| Today's Posts |
|
#6
|
|||
|
|||
Hi,
You may use an array formula (Ctrl+Shift+Enter) to arrive at the same result =count(if((range1="--")*(range2="--"),1,0)) Regards, Ashish Mathur "tw5633" wrote: I am trying to make a count of sales by salesperson. In column I, I have "salesperson(DP,PR,BD)", and in column N, I have "sales status (S,NI,L,P,F)". I want to find out how many "sales(S)", each person has. In a description =COUNTIF(N:N,"=DP")IF(I:I,"=S") this is basically what I am trying to say. I know that this is not the correct formula, I have been trying others, however I haven't had success. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| analysing data from alternate columns using the countif function | Excel Discussion (Misc queries) | |||
| Combining IF and COUNTIF based on two columns | Excel Discussion (Misc queries) | |||
| want to count in two columns; countif (colA=x AND colB=y)? | Excel Worksheet Functions | |||
| Pivot Table combining multiple columns | Excel Discussion (Misc queries) | |||
| combining 3 columns of same info for a pivot table | Excel Worksheet Functions | |||
Threaded Mode
