Try these:

=SUMPRODUCT((A2:A8=8)*(B2:B8={"CT3","CT4"}))

=SUMPRODUCT((A2:A8=10)*(B2:B8={"CT3","CT4"}))

--
Biff
Microsoft Excel MVP


"LaTanya" wrote in message
...
I am trying to count text and number in in column

example-I need a function that will count across two columns
If the training hours =8 and Taining Type =CT3 or CT4
Results Would be =1

If the training hours =10 and Taining Type =CT3 or CT4
Results Would be =2

Column-1 Column-2
Training Hours Training Type
8 CT3
10 CT4
8 LR
8 QC
8 RSV
10 CT3
10 QC



Thanks
LaTanya R.