The ranges need to be the same size. Use C2:C5054.

Also, use the first formula you give below. The one I gave you is incorrect.

Dave
--
Brevity is the soul of wit.


"Tammy" wrote:

Dear guys - I tried both:

=SUMPRODUCT(--('Utilization Detail'!B2:B5054="tul"),--('Utilization
Detail'!C2:C5000="Agent"))


=SUMPRODUCT(('Utilization Detail'!B2:B5054="tul"),('Utilization
Detail'!C2:C5000="Agent"))

and both return #Value! errors? Any advice please?
"bj" wrote:

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