Forum Discussion
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...
pls see attached sample..
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