Forum Discussion
having problem with formula for totalling number of items received on different days in the month
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
If you use Excel Tables for manual data input, the data ranges grow automatically as data is added.
By using a dynamic array for the dates in the daily summary, that too will grow as required.
The formulas I used were
EndDate: =MAX(PO[Date])
Date: =SEQUENCE(1+endDate-startDate, 1, startDate)
RequisitionCount: = COUNTIFS(PO[Date], Date#)
RequisitionValue: =SUMIFS(PO[Amount (ex.VAT)], PO[Date], Date#)
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.
