Forum Discussion
having problem with formula for totalling number of items received on different days in the month
Hi, I am trying input a formula that works for totalling number of items received on different days in a month. I have set up a worksheet that counts items raised on each day in the main spreadsh...
Hi there. Seems Pivot table would be the fastest solution here. Is there a particular reason why would you like to have monthly data in a separate Workbook? Please see file attached. There is an extra sheet added where monthly data is aggregated and also a Pivot Table which shows daily and monthly data.
thank you. I think I've sorted it now.