yeah Teethless! The 2nd one you listed below worked! Thanks everyone.

"Teethless mama" wrote:

Should be:

=Sumproduct(--(criteria 1),--(criteria 2)
or
=Sumproduct((criteria 1)*(criteria 2))

It will not work with
=Sumproduct((criteria 1),(criteria 2)


"Dave F" wrote:

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