Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Countif + vLookup: Can they work together?
Can I set a countif function to count the number of times a name i.e. "Jim"
appears in column B in any worksheet in a single workbook where the value in the same row of column E equals "Assigned"? Thanks for any help! Jeff |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Countif + vLookup: Can they work together?
I believe this formula can help you to get you want. Extend the range to your needs ... {=SUM(IF(B2:B1000="Jim",IF(E2:E1000="Assigned",1,0 )))} -- prague ------------------------------------------------------------------------ prague's Profile: http://www.excelforum.com/member.php...o&userid=30172 View this thread: http://www.excelforum.com/showthread...hreadid=516086 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Countif + vLookup: Can they work together?
=SUM(IF(A2:A7="Buchanan",IF(B2:B7=9000,1,0))) Input this into the cell you want the result to appear, Press "F2" then Ctrl+Shift+Enter Will show you the results ... :) -- prague ------------------------------------------------------------------------ prague's Profile: http://www.excelforum.com/member.php...o&userid=30172 View this thread: http://www.excelforum.com/showthread...hreadid=516086 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Countif + vLookup: Can they work together?
=sumproduct(--(b1:b10="jim"),--(e1:e10="assigned"))
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 http://www.xldynamic.com/source/xld.SUMPRODUCT.html And J.E. McGimpsey has some notes at: http://mcgimpsey.com/excel/formulae/doubleneg.html Spyder wrote: Can I set a countif function to count the number of times a name i.e. "Jim" appears in column B in any worksheet in a single workbook where the value in the same row of column E equals "Assigned"? Thanks for any help! Jeff -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Forget SUMIF, COUNTIF and VLOOKUP | Excel Worksheet Functions | |||
Getting #N/A from Vlookup when matching value exist in the lookup data range. | Excel Worksheet Functions | |||
Vlookup doesn't work until i edit(but not change) the lookup cell | Excel Worksheet Functions | |||
VLOOKUP Problem (limitation)? | Excel Worksheet Functions | |||
creating an invoice for work | Excel Worksheet Functions |