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...
That's bit abstract, perhaps you may illustrate on the sample. It you'd like to aggregate for each date most probably it's better to use PivotTable.
- SergeiBaklan I have just uploaded something.
Thank you. I'm not sure that exactly do you mean under "total value of requistion raised", perhaps formula could be
=SUMIF(Sheet2!A:A,A2,Sheet2!G:G)Please check attached.
- SergeiBaklan. Thanks. It works but I wanted it to calculate automatically anything that I add to the main spreadsheet for each day. Eventually, I wanted to do another workbook that shows the data for each month. So for all transactions for April, I wanted to show the number of transactions and the total amount of those transactions for each day. Sorry if I'm not being very clear
