Embedded countif statements?

[klynshoe]

Hello,

I have the following formula which provides a % value of any cell within the range specified that is a 1 or 2.

=(COUNTIF(Metrics!$P$3:$P$12,1)+COUNTIF(Metrics!$P$3:$P$12,2))/COUNT(Metrics!$P$3:$P$12)

I would like to narrow this down even further by only counting the values in the range where the cell in $B2 (Column B) equals a particular value. At first I tried an IF/THEN stmt but that only gave me the one count in that row, instead of counting everything with that value in Column B. Now I'm stuck! I may have to an array of sorts buy my experience with arrays is limited so I would need add'l assistance in setting that up if that's the best way to go about it.

Any advice would be greatly helpful!

EXCEL 2010

 

[dropanddrive03]

I'm not sure if I correctly understand your question. Have you tried just changing the 1 and 2 to cell references? Assuming you have, can you either embed the sheet or send a dropbox link or something like that? It's much easier to help when I can see exactly what you're doing...

 

[klynshoe]

Nevermind, I figured out I can accomplish this using COUNTIFS instead. I wasn't familiar with that function and figured it out. woo hoo!