| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
How do I write a conditional statement in Excel to count if two c.
I need to count how many times in a list that a name comes up with a certain
date. |
|
#2
|
|||
|
|||
|
=sumproduct(--(a1:a10="marblelife"),--(b1:b10=date(2005,1,16))
is one way marblelife wrote: I need to count how many times in a list that a name comes up with a certain date. -- Dave Peterson |
|
#3
|
|||
|
|||
|
=SUMPRODUCY(--(A1:A100="the_name"),--(b1:b100=--"2004/01/15"))
-- HTH Bob Phillips "marblelife" wrote in message ... I need to count how many times in a list that a name comes up with a certain date. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
| Conditional formatting not available in Excel | Excel Discussion (Misc queries) | |||
| Is it possible to do a conditional subtotal in Excel? | Excel Worksheet Functions | |||
| Conditional Formats in Excel | Excel Worksheet Functions | |||
| How can I use count function in excel where I have several criter. | Excel Worksheet Functions | |||
Hybrid Mode
