You would have to use SUMPRODUCT:

=SUMPRODUCT((B:B="lex"),(C:C="Agent"))

However, in order to use the B:B or C:C reference I believe you need XL
2007. If you're not using that you need to specify your range, i.e.,
B1:B10000, etc.

Dave
--
Brevity is the soul of wit.


"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")