Forum Discussion

Mark Stevens's avatar
Mark Stevens
Copper Contributor
Nov 15, 2018

sumproduct

I am a novice with Excel so seeking advice on the use of SUMPRODUCT.  From a summary table on a separate worksheet, I am seeking to refer to a table with data in columns A,B and F on worksheet CASH R...
excel
  • Mark Stevens's avatar
    Mark Stevens
    Copper Contributor
    Nov 15, 2018

    Hi Lorenzo

    Thank you very much for your efforts on this, much appreciated.  In retrospect, I should have attached an example of the spreadsheet.  As the CASH PAYMENT and CASH RECEIPT sheets are completed, I was hoping that the PROFIT/LOSS sheet would automatically update with the total $amounts according to month and category.  Note that the category column is populated with the aid of a drop down menu.  Not sure if that complicates the issue.  If you could suggest a formula for one of the cells on the PROFIT/LOSS sheet then that would be a great help.  Regards Mark

      • Mark Stevens's avatar
        Mark Stevens
        Copper Contributor
        Nov 16, 2018

        Thank you very much Lorenzo; this is certainly way outside my capabilities with regards use of formulae etc.  I will test and try and understand what the formula is doing when I have more time over the weekend.  At a glance it appears that the formula automatically recognises the date  and category in the CASH RECEPT sheet without specifying eg 1,2,3 for Jan, Feb Mar etc or ="Judges Expenses"... etc.  Once I understand, I will set up the CASH PAYMENT calculations.  Just to clarify, once this is done, I assume the PROFIT/LOSS sheet will automatically update as I enter data in the other sheets.  Much appreciated - Mark

Resources