On my sheet named "Peer Company Summary", I'd like to count the number cells with the value of 1 on my sheet named "Raw Data" on Column D, with respect to it matching the company name on "Peer Company Summary" on Column A to match Column A on "Raw Data" as well.
How would I count the total number as well? Some values on Column D on "Raw Data" have the values 1, 2, or 3 and I'd like to count all that with respect to the company name.
What formula would I use? This is MS Excel 2010.
