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
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
- Hi received this mail..below but can't trace where the results are, sorry for being dense
..mail begin..
Hi
Microsoft Tech Community <MicrosoftTechCommunity@us.khoros-mail.com>
Mon 04/10/2021 06:34
Here's the main Pivot View:
with the formula count below it, and other pivot views above and below it.:
cheers
mail end....