software

Can I set a countif function to count the number of times a name i.e. quot;Jimquot;
appears in column B in any worksheet in a single workbook where the value in
the same row of column E equals quot;Assignedquot;?

Thanks for any help!
Jeff


I believe this formula can help you to get you want. Extend the range to
your needs ...

{=SUM(IF(B2:B1000=quot;Jimquot;,IF(E2:E1000=quot;Assignedquot;,1,0 )))}--
prague
------------------------------------------------------------------------
prague's Profile: www.excelforum.com/member.php...oamp;userid=30172
View this thread: www.excelforum.com/showthread...hreadid=516086
=SUM(IF(A2:A7=quot;Buchananquot;,IF(B2:B7=9000,1,0)))

Input this into the cell you want the result to appear, Press quot;F2quot; then
Ctrl Shift Enter

Will show you the results ... --
prague
------------------------------------------------------------------------
prague's Profile: www.excelforum.com/member.php...oamp;userid=30172
View this thread: www.excelforum.com/showthread...hreadid=516086=sumproduct(--(b1:b10=quot;jimquot;),--(e1:e10=quot;assignedquot;))

Adjust the range, but don't use the whole column.

=sumproduct() likes to work with numbers. The -- stuff changes trues and falses
to 1's and 0's.

Bob Phillips explains =sumproduct() in much more detail he
www.xldynamic.com/source/xld.SUMPRODUCT.html

And J.E. McGimpsey has some notes at:
mcgimpsey.com/excel/formulae/doubleneg.html

Spyder wrote:
gt;
gt; Can I set a countif function to count the number of times a name i.e. quot;Jimquot;
gt; appears in column B in any worksheet in a single workbook where the value in
gt; the same row of column E equals quot;Assignedquot;?
gt;
gt; Thanks for any help!
gt; Jeff

--

Dave Peterson