Forum Discussion
Solved
Trying to count text using a date as reference
Need help to count the number of items based on a date. my dates 01-Dec through to 25-dec are in column c. the items i need to count are in columns d through to ac there are 9 possible types of item...
- Brilliant 🙂
Only problem my mac doesn't support slicers 🙂 but really thank you much appreciated
rgds
PivotTable could work, do you consider such option?
thanks for the reply, i was looking to making a new sheet with the date specific to the date and item numbers hence the formula idea but i will certainly look at the pivot table idea thanks good idea.. However It's annoying that my formula only produces a zero a like to know where i'm going wrong
If you provide small sample file and mention on which Excel version / platform you are, we may try to play with formulas for your case.
Hi Sergei
Much appreciated
File attached, i'm trying to build the table on the Orders Tab, from the test date on the form response tab.
- forgot to add using 2011 on a mac