| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
count using multiple criteria
Column A has texts Column B has dates Want to count rows having text='Apples' for dates between today and 14 days back. In other words read it as "counting number of Apple sale transactions for a fortnight. I want to write a user defined VBA function that can be called in excel sheet cells. I tried countif but it takes only one criteria. Tried 'count' and 'if' together and also 'sum' but could not succeed much. How we can achieve above mentioned counting. Thanks. -- nougain ------------------------------------------------------------------------ nougain's Profile: http://www.excelforum.com/member.php...o&userid=32031 View this thread: http://www.excelforum.com/showthread...hreadid=528499 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count with multiple criteria in multiple cells | Excel Worksheet Functions | |||
| 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 | |||
![nougain[_7_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
