Now I have a new problem

example-I need a function that will count across two columns
If Column B =Meeting or Vac and it's less than 8 or 10 hrs, I need a formula
that would count the discriptor and add the hours

if b12:b15=MT or VAC or TRN and c12:b15 is less than 8hr or 10hr= sum of the
hours

Thanks Again for your help

LaTanya R.

"T. Valko" wrote:

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.