klynshoe
Board Regular
- Joined
- Jun 17, 2010
- Messages
- 176
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
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