Excel Count Formula

R

Ronil Patel

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
 
P

Peo Sjoblom

=SUMPRODUCT(--(A2:A1000="AD"),--(R2:R1000=1))

If the 1 is a text 1 enclose it in apostrophes "1"


Regards,

Peo Sjoblom
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Autonumber field in Excel that behaves the same as Access 0
Section and Page numbering 0
Countif or other formula needed for multiple data/critera results 3
Count Number of Unique Cells That Don't Have Certain Characters 0
Excel - Wich Function should I use? 1
Formula For Counting Records 5
Trying to count based on multiple criteria & cell comparisons 4
Formula Count dates multiple criteria 3

Top