Excel 2003
Excel 2003
(OP)
Primary Secondary
F V
P T
F T
L V
H Y
F V
T T
X V
F I
F T
T T
P V
H V
Z SC
H V
F V
L V
H Y
F I
Above excel data on "sheet1". On sheet 2 tryin to count say e.g. number of "FV"s. Any suggestion for formula.
Thanks.
F V
P T
F T
L V
H Y
F V
T T
X V
F I
F T
T T
P V
H V
Z SC
H V
F V
L V
H Y
F I
Above excel data on "sheet1". On sheet 2 tryin to count say e.g. number of "FV"s. Any suggestion for formula.
Thanks.





RE: Excel 2003
Francis
www.controldraw.co.uk
www.s88control.blogspot.com
RE: Excel 2003
RE: Excel 2003
=if(and(a1="F",b1="V"),1,0)
if cell values are in same column, the try
=if(a1="F V",1,0)
you can then sum or count the "ones". crude method, but works.
good luck.
-pmover
RE: Excel 2003
Good luck,
Latexman