| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Countifs -Count no of times products have been sold on particular
"T. Valko" wrote in message ... Excel is kind of picky when you refer to a date in a formula and there's also the issue of date ambiguity. <snip As a last resort (I don't like this method!): =COUNTIFS(H$3:H$398,""&--"2008/11/18",J$3:J$398,"0") You don't need the double unary and this ISO standard format is the best IMO =COUNTIFS(H$3:H$398,"2008-11-18",J$3:J$398,"0") |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| inventory Add, Cost, Sold, Sold price - formula | Excel Discussion (Misc queries) | |||
| count text appear how many times & put in respec col??eg 1st times | Excel Discussion (Misc queries) | |||
| Count Products | Excel Worksheet Functions | |||
| Need formula to count number of books sold | Excel Worksheet Functions | |||
| Combine query to count products with similar names | Excel Worksheet Functions | |||
![Bob Phillips[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
