| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Count if 3 different conditions exist
I have 3 columns of information. Column A has a date (01-Jan-05), column B has a name, column C has either F, Inf, or Inv. I want a formula that will count any date in column A that is January, and column B is Adam, and column C is F. -- AnnaV ------------------------------------------------------------------------ AnnaV's Profile: http://www.excelforum.com/member.php...fo&userid=9619 View this thread: http://www.excelforum.com/showthread...hreadid=496989 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Count if 3 different conditions exist
=SUMPRODUCT(--(MONTH(A2:A200=1),--(B2:B200="Adam"),--(C2:C200="F"))
-- HTH RP (remove nothere from the email address if mailing direct) "AnnaV" wrote in message ... I have 3 columns of information. Column A has a date (01-Jan-05), column B has a name, column C has either F, Inf, or Inv. I want a formula that will count any date in column A that is January, and column B is Adam, and column C is F. -- AnnaV ------------------------------------------------------------------------ AnnaV's Profile: http://www.excelforum.com/member.php...fo&userid=9619 View this thread: http://www.excelforum.com/showthread...hreadid=496989 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Count if 3 different conditions exist
Put the number of the month you're looking for in D1 (Jan=1, Feb=2,
etc....), Name in D2, And ID's in D3, Then try this: =SUMPRODUCT((MONTH(A1:A100)=D1)*(B1:B100=D2)*(C1:C 100=D3)) -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "AnnaV" wrote in message ... I have 3 columns of information. Column A has a date (01-Jan-05), column B has a name, column C has either F, Inf, or Inv. I want a formula that will count any date in column A that is January, and column B is Adam, and column C is F. -- AnnaV ------------------------------------------------------------------------ AnnaV's Profile: http://www.excelforum.com/member.php...fo&userid=9619 View this thread: http://www.excelforum.com/showthread...hreadid=496989 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Count if 3 different conditions exist
It Works! It Works! It Works! Thank You! -- AnnaV ------------------------------------------------------------------------ AnnaV's Profile: http://www.excelforum.com/member.php...fo&userid=9619 View this thread: http://www.excelforum.com/showthread...hreadid=496989 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Count if 3 different conditions exist
Try this:
=SUMPRODUCT(--(MONTH(A1:A100)=1),--(B1:B100="Adam"),--(C1:C100="F")) And of course, change the cell ranges to match your needs. HTH, Elkar "AnnaV" wrote: I have 3 columns of information. Column A has a date (01-Jan-05), column B has a name, column C has either F, Inf, or Inv. I want a formula that will count any date in column A that is January, and column B is Adam, and column C is F. -- AnnaV ------------------------------------------------------------------------ AnnaV's Profile: http://www.excelforum.com/member.php...fo&userid=9619 View this thread: http://www.excelforum.com/showthread...hreadid=496989 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Advanced unique cell count with multiple conditions ... help! | Excel Worksheet Functions | |||
| Count the number of Cells in one ROW with conditions | Excel Worksheet Functions | |||
| returning a count if two conditions are met | Excel Worksheet Functions | |||
| How do I count number of cels the matches 2 conditions ? | Excel Worksheet Functions | |||
| Count If Formula for multiple conditions?? How To?? | Excel Worksheet Functions | |||
Hybrid Mode
