CODEWITHSUNDEEP
excelexcel-formulaexcel-2010
Rich
Rich

Reputation: 5

Count cells based on multiple values

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.

Peer Company Summary Sheet

Raw Data

Upvotes: 0

Views: 55

Answers (1)

Scott Craner
Scott Craner

Reputation: 152450

Use COUNTIFS. Put this in D2 and copy over and down

=COUNTIFS('Raw Data'!$A:$A,$A2,'Raw Data'!$D:$D,COLUMN(A:A))

Upvotes: 0

Related Questions