Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
counting with multiple criteria
I want to count the number of cells in column B, where two criteria is true. I.e. i want to count the number of cells in column B that equal 01/01/2006 where A7:A3000 = C7 and also B7:B3000 = 01/01/2006 Thanks Andy -- Andyd74 ------------------------------------------------------------------------ Andyd74's Profile: http://www.excelforum.com/member.php...o&userid=34013 View this thread: http://www.excelforum.com/showthread...hreadid=545016 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
counting with multiple criteria
Try this =sumproduct(--(a7:a3000=c7),--(b7:b3000="01/01/2006"+0)) -- daddylonglegs ------------------------------------------------------------------------ daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486 View this thread: http://www.excelforum.com/showthread...hreadid=545016 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
counting with multiple criteria
=SUMPRODUCT(--(A7:A3000="C7"),--(B2:B3000=--"2006-01-01"))
-- HTH Bob Phillips (remove xxx from email address if mailing direct) "Andyd74" wrote in message ... I want to count the number of cells in column B, where two criteria is true. I.e. i want to count the number of cells in column B that equal 01/01/2006 where A7:A3000 = C7 and also B7:B3000 = 01/01/2006 Thanks Andy -- Andyd74 ------------------------------------------------------------------------ Andyd74's Profile: http://www.excelforum.com/member.php...o&userid=34013 View this thread: http://www.excelforum.com/showthread...hreadid=545016 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
counting with multiple criteria
Hi
Try this: =SUMPRODUCT(--(A7:A3000=$C$7),--(B7:B3000=DATEVALUE("01/01/2006"))) You have column B twice in your explanation, by the way. I've put it in once. I've also assumed that your reference to C7 is absolute. This is untested. Hope this helps. Andy. "Andyd74" wrote in message ... I want to count the number of cells in column B, where two criteria is true. I.e. i want to count the number of cells in column B that equal 01/01/2006 where A7:A3000 = C7 and also B7:B3000 = 01/01/2006 Thanks Andy -- Andyd74 ------------------------------------------------------------------------ Andyd74's Profile: http://www.excelforum.com/member.php...o&userid=34013 View this thread: http://www.excelforum.com/showthread...hreadid=545016 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Multiple criteria LOOKUP | Excel Worksheet Functions | |||
Multiple Criteria | Excel Worksheet Functions | |||
Help w/ counting multiple columns based on IF criteria | Excel Worksheet Functions | |||
Multiple Criteria in SumProduct, N/A Result | Excel Worksheet Functions | |||
Multiple Criteria IF Nesting | Excel Worksheet Functions |