=countif ???
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")
|