if you want to count when both criteria are met try
=sumproduct(--('Utilization Detail'!B1:B1000="lex"),--('Utilization
Detail'!C1:C1000="Agent"))
with sumproduct, you can't use the shorthand for entire columns or rows
the "--(" changes the true/false logic response to 1/0 numeric.

if you want when either are met try
=COUNTIF('Utilization Detail'!B:B,"lex") + ('Utilization Detail'!C:C,"Agent")

"Tammy" wrote:

Can I specify two columns to pull info from? For example - what is wrong
with this formula?

COUNTIF('Utilization Detail'!B:B,"lex") AND ('Utilization Detail'!C:C,"Agent")