Hi,
I received help from the group some weeks ago suggesting I use SUMIFS to group and calculate household bills that trying to analyse.
I've attached a sample Excel file.
Although I'm a relative newbie to Excel, I feel what I'm trying to achieve is pretty basic stuff, but I'm running into problems.
I'm using Excel For Mac v16.29.1 on an iMac 2011 generation, running High Sierra 10.13.6
The Bills are entered in a random date order. New 'Suppliers', 'Categories' and 'Source'* are added to columns A & B respectively in a separate Data! sheet which are used to make a drop down tables (*'Source' being a code describing how the bill was paid and by whom).
From the randomly entered Bills I want to find totals by various date ranges ( Yr, Monthly, Weekly) for each 'Category', 'Supplier' and & 'Source'.
I entered a test SUMIFS code at K3 to extract from the sample Bills any bill for 2017 that met the Category criteria of M2.
I found that apart from not working, I realise that I would need to hand code all the date ranges rather than use cell references. But there is an even more basic problem: how can I create a code that I don't need to update to reference the range of bills - i.e. the first is always going to be at Row 3, but I've no idea where it will end, indeed the point is it's meant to be on-going.
I hope ya'll will be able to understand what I'm trying to achieve and can give some help.
Many thanks.
Hal.
Bookmarks