Oct 02 2021 08:11 AM
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
Oct 02 2021 08:37 AM
PivotTable could work, do you consider such option?
Oct 02 2021 08:49 AM
Oct 02 2021 09:05 AM
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.
Oct 02 2021 10:45 AM
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.
Oct 02 2021 10:49 AM
Oct 05 2021 01:31 AM
Oct 05 2021 01:35 AM
I removed it because my solution is not based on mac but here take a look see if you can work it out
Oct 05 2021 01:53 AM
Oct 05 2021 02:36 AM
I modified it full Pivot View with slicers if its counts you need counts you will get:
Sliced View:
Sliced View with two party times:
Oct 05 2021 02:50 AM
SolutionOct 05 2021 02:55 AM
That's your business we're talking about, If you want to drive a ferrari in the numbers farm suit yourself or you can buy a Windows Pick-up truck for your farm. Its your business.
cheers
Oct 05 2021 02:50 AM
Solution