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 items
i'm trying to use a formula to know how many specific items i have on a specific date.
ie. on the 01 December how many 1's, 2's 3's items ect there are
i'm trying countifs but can't make the formula work across the multiple columns
- Brilliant 🙂
Only problem my mac doesn't support slicers 🙂 but really thank you much appreciated
rgds
12 Replies
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.
