Hello!! I am a newbie so I have to get out the usual thank the lord for the board and its users, etc. So...
I have text in clumns A and B but only want to count certain entries in A based on the entry in B.. Detailed question after the html code...
Thanks in advance!! :D
I need a formula to count how many times DAVE received an order from DIAMOND.
I assumed something like =COUNT(B:B,"DIAMOND")*IF(A:A,DAVE) but that doesn’t work
ALSO
I need a formula to count how many times DAVE received an order from DIAMOND that were 'completed'.
I have text in clumns A and B but only want to count certain entries in A based on the entry in B.. Detailed question after the html code...
Thanks in advance!! :D
Book1.xls | ||||||||
---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | |||
1 | AGENT | ORDERSOURCE | COPLETED | SOURCE | TOTAL | DAVE | ||
2 | MIKE | DIAMOND | YES | DIAMOND | 3 | #VALUE! | ||
3 | DAVE | DIAMOND | YES | CLAY | 2 | |||
4 | JIM | MILLER | NO | MILLER | 4 | |||
5 | MIKE | CLAY | YES | TOTALS | 9 | |||
6 | MIKE | DIAMOND | YES | |||||
7 | JIM | MILLER | NO | COMPLETED | 6 | |||
8 | JIM | MILLER | YES | NOTCOMPLETE | 3 | |||
9 | JIM | CLAY | NO | |||||
10 | APRIL | MILLER | YES | |||||
needtextcountingformulas |
I need a formula to count how many times DAVE received an order from DIAMOND.
I assumed something like =COUNT(B:B,"DIAMOND")*IF(A:A,DAVE) but that doesn’t work
ALSO
I need a formula to count how many times DAVE received an order from DIAMOND that were 'completed'.