I know someone will have the answer to this, but I don’t know if I’ll make a hash of explaining it!.
Here goes …
I have a spreadsheet with my inventory of books that I sell, and I have the date sold in there as well as cost price, sale price and profit, etc - but I’m looking to create another sheet which will give me running totals on a month to month basis on my profit, preferably with a total of books sold too. So, if I have sheet 1 showing the date sold in column “B”, quantity in column “C” and the profit in column “D”, I’d like to have sheet 2 to give me totals, so for example, if I had 30 entries (rows) on sheet 1 showing I have sold 30 books in August, in sheet 2 I’d like it to show the total items sold (i.e. calculates totals in column “C” where the month “August” has been used in column “B”, and totals in column “D” where the month “August” has been used in column “B”. The same would be applied for the other months but once I have the formula for one month I’d be able to work out the rest.
Hope this all makes sense and look forward to the replies
All the best