| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Count if with multiple criteria
Hi
if you are using XL2007, try this COUNTIFS =COUNTIFS(A:A,""&DATE(2005,8,1),A:A,"<"&DATE(2008 ,7,31),B:B,"19") -- Hope this is helpful Pls click the Yes button below if this post provide answer you have asked Thank You cheers, francis Am not a greek but an ordinary user trying to assist another "Raquel" wrote: I have a spreadsheet that I am trying to do a count if formula on. The first column contains a date. The second column contains a number. I want to count if Column A has a date between 8/1/2005 and 7/31/2008 and if column B has 19 in it. Is anyone familiar with this? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Filter Multiple Columns on Multiple Criteria and count the last co | Excel Worksheet Functions | |||
| To count the data using multiple criteria in multiple columns | New Users to Excel | |||
| Count multiple cells against multiple criteria in an Excel spreads | Excel Worksheet Functions | |||
| Multiple Criteria, Count If, Sum Product to get count across range | Excel Worksheet Functions | |||
| Count multiple criteria | Excel Worksheet Functions | |||
Hybrid Mode
