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

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

Lorenzo Kim

Bronze Contributor

Nov 15, 2018

pls find the sample attached.

hope you can make something out of this.

thanks..

Forum Discussion

sumproduct