having problem with formula for totalling number of items received on different days in the month

Question

&nbsp;Hi, I am trying input a formula that works for totalling number of items received on different days in a month.&nbsp; I have set up a worksheet that counts items raised on each day in the main spreadsheet.&nbsp; However, I want to work out the total value of items raised for each day.&nbsp; I've tried sum product and various others, but nothing works, instead it just returns a "0" which isn't right.&nbsp; Can you tell me where I am going wrong?&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

sergeibaklan · Answer

pachesta&nbsp;
To show result for the date it's better to use Excel Tables, it automatically expand calculations with expanding the table

To show totals for the month it depends on how you'd like to select the month (in general an year as well), will it be separated table with totals for each yearmonth, or you select them from drop-down list(s) or what.
&nbsp;

sergeibaklan · Answer

pachesta&nbsp;
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.

nikolinode · Answer

pachesta&nbsp;With your permission, it can help us all if you upload an Excel file (without sensitive data), no picture. Even if it is said that a picture can say a thousand words, it is certainly not in the case of Excel, on the contrary in some cases. This would also be a blessing for all of us, as we can understand the problem much better, a win-win situation for everyone.Knowing the Excel version and operating system would also be an advantage...for you.&nbsp;Thank you for your understanding and patience&nbsp;NikolinoI know I don't know anything (Socrates)

pachesta · Answer

SergeiBaklan I have just uploaded something.

pachesta · Answer

NikolinoDE I am using Microsoft Excel 365

Forum Discussion

having problem with formula for totalling number of items received on different days in the month

10 Replies

Resources