ironj32
12-03-2009, 07:20 AM
Sorry if this been asked and answered before, but I've done a lot of searches and cannot find anything.
In the example below, I need to try to take a Count of ColC IF ColB=1. So the result from the two columns below would be 3.
ColB ColC
1 100%
2 99%
4
3 90%
1
4 100%
1 98%
1 100%
I've tried the following formulas but have not had any success.
=COUNT($C:$C,$B:$B=1)
=IF(B:B=1,COUNT(!C:C))
=COUNTA(IF($B:$B=1,$C:$C))
=COUNTIF($C:$C,$B:$B=1)
Any help would be greatly appreciated!
In the example below, I need to try to take a Count of ColC IF ColB=1. So the result from the two columns below would be 3.
ColB ColC
1 100%
2 99%
4
3 90%
1
4 100%
1 98%
1 100%
I've tried the following formulas but have not had any success.
=COUNT($C:$C,$B:$B=1)
=IF(B:B=1,COUNT(!C:C))
=COUNTA(IF($B:$B=1,$C:$C))
=COUNTIF($C:$C,$B:$B=1)
Any help would be greatly appreciated!