Spreadsheet: 38344d1236480586-help-to-solve-counting-result-one-col-if-criteria-in-another-col-true-internet-log
Sheet: Sheet2

INTERNET LEAD LOG |  | TOTAL LEADS MTD | % TOTAL | LEAD NEW | % TOTAL | LEADS USED | % TOTAL
 |  | 26 | 1 | 14 | 0.5384615384615384 | 12 | 0.4615384615384616
 |  | SOURCE |  | NEW SRCE |  | USED SRCE
 | WEBSITE | 4 | 0.1538461538461539 | #N/A | #N/A |  | In this cell I want to see answer to:
 | CARSALES | 17 | 0.6538461538461539 |  |  |  | Of the 4 SOURCE = "WEBSITE" in c4, how many were "NEW" from d26:d51?
 | DRIVE | 1 | 0.03846153846153846
 | HOLDEN | 3 | 0.1153846153846154
 | HSV | 1 | 0.03846153846153846
 | NAME | LEADS REC'D | SOLD | CARRY FWD | DEAD | [NAME] LEADS
 | ANGELO | 2 | 12 | 3 | 11 | 6
 | BEVAN | 2
 | BRUCE | 1 |  |  |  |  | In this cell I want to see answer to:
 | COLM | 2 |  |  |  |  | Of the 2 LEADS REC'D in C10, how many are "SOLD" from COL d26:d51?
 | DANNY | 0
 | GREG | 3
 | JAN | 0
 | [NAME] | 0
 | [NAME] | 0
 | [NAME] | 2
 | NATHAN | 0
 | ROB | 14
 | SIMON | 0
 |  | DATA ENTERED DAILY AS INTERNET LEADS ARRIVE
DATE | ENQUIRER | SOURCE | INTEREST IN | SENT TO | OUTCOME | COMMENT |  |  |  |  |  |  |  | SOURCE | INTEREST IN | SENT TO | OUTCOME
2009-02-01 00:00:00 | SMITH | WEBSITE | NEW | ANGELO | DEAD |  |  |  |  |  |  |  |  | WEBSITE | NEW | ANGELO | SOLD
2009-02-02 00:00:00 | JONES | WEBSITE | NEW | ANGELO | SOLD |  |  |  |  |  |  |  |  | CARSALES | USED | BEVAN | CARRY FWD
2009-02-03 00:00:00 | SMITH | CARSALES | NEW | BEVAN | CARRY FWD |  |  |  |  |  |  |  |  | DRIVE |  | BRUCE | DEAD
2009-02-04 00:00:00 | JONES | CARSALES | NEW | GREG | CARRY FWD |  |  |  |  |  |  |  |  | HOLDEN |  | COLM
2009-02-05 00:00:00 | SMITH | CARSALES | NEW | BRUCE | SOLD |  |  |  |  |  |  |  |  | HSV |  | DANNY
2009-02-06 00:00:00 | JONES | DRIVE | NEW | BEVAN | SOLD |  |  |  |  |  |  |  |  |  |  | GREG
2009-02-07 00:00:00 | SMITH | HOLDEN | NEW | GREG | SOLD |  |  |  |  |  |  |  |  |  |  | GREG
2009-02-08 00:00:00 | JONES | HOLDEN | NEW | GREG | DEAD |  |  |  |  |  |  |  |  |  |  | JAN
2009-02-09 00:00:00 | SMITH | HSV | NEW | COLM | DEAD |  |  |  |  |  |  |  |  |  |  | [NAME]
2009-02-09 00:00:00 | JONES | HOLDEN | NEW | COLM | DEAD |  |  |  |  |  |  |  |  |  |  | [NAME]
2009-02-09 00:00:00 | SMITH | WEBSITE | NEW | [NAME] | CARRY FWD |  |  |  |  |  |  |  |  |  |  | [NAME]
2009-02-09 00:00:00 | JONES | WEBSITE | NEW | [NAME] | SOLD |  |  |  |  |  |  |  |  |  |  | NATHAN
2009-02-09 00:00:00 | SMITH | CARSALES | NEW | ROB | SOLD |  |  |  |  |  |  |  |  |  |  | ROB
2009-02-09 00:00:00 | JONES | CARSALES | NEW | ROB | DEAD |  |  |  |  |  |  |  |  |  |  | SIMON
2009-02-09 00:00:00 | SMITH | CARSALES | USED | ROB | SOLD
2009-02-09 00:00:00 | JONES | CARSALES | USED | ROB | DEAD
2009-02-09 00:00:00 | SMITH | CARSALES | USED | ROB | SOLD
2009-02-09 00:00:00 | JONES | CARSALES | USED | ROB | DEAD
2009-02-09 00:00:00 | SMITH | CARSALES | USED | ROB | SOLD
2009-02-09 00:00:00 | JONES | CARSALES | USED | ROB | DEAD
2009-02-09 00:00:00 | SMITH | CARSALES | USED | ROB | SOLD
2009-02-09 00:00:00 | JONES | CARSALES | USED | ROB | DEAD
2009-02-09 00:00:00 | SMITH | CARSALES | USED | ROB | SOLD
2009-02-09 00:00:00 | JONES | CARSALES | USED | ROB | DEAD
2009-02-09 00:00:00 | SMITH | CARSALES | USED | ROB | SOLD
2009-02-09 00:00:00 | JONES | CARSALES | USED | ROB | DEAD