I Have a spread sheet if 10,000 records. In column A, I have a salespersons
initials. In another column(ex. R) the cell is either blank or has a 1. 1
states that the product was sold.

Can someone help me out with a formula which will add up the number if both
fields are True. I have tried many formulas but was unseccessful. How would i
be able to write a formula which would look like the following.

Count=(A:A=AD and R:R=1) i need both columns for that record to match in
order for it to add.

PLEASE HELP!!!

Thank You