Hi,
I have spreadsheet to store information of boxes in the offsite storage company. Inside boxes, we file folders for different clients' building. So, one box number may have more than one building.
I attach the spreadsheet. At column Cell N8, I want to use countif formula to count how many boxes we retrieve on April 11, 2016. The correct number should be 2. However, I can't fix the formula (it shows 5 as I use countif).
If the formula successful, I do not need column: Number of box. Every time I need to manually input
We have 10000 boxes, I make this sample excel for your reference.
I also try to use formula, Frequency, however, not sucessful , so i do not put in excel
=SUM(IF(FREQUENCY(IF($E$3:$E$9998<>"",IF($D$3:$D$9998="BUTLER BOX permanently removal",MATCH($E$3:E9998,E3:$E$9998,0))),ROW($E$3:$E$9998)-ROW($E$3)+1),1))
Thanks very much
Bookmarks