Forum Discussion
Is there a function to multiple same row of two tables? MMULT does not
Is there a function to multiple cell for cell of two Tables? Otherwise, to use MMULT, my understanding is I need to transpose; if so, wouldn't date information across a row of columns become unconven...
Don't you want a simple SUMPRODUCT?
=SUMPRODUCT('2023 CAD Exchange'!B2:D13, 'HSBC Deposits in CAD'!B2:D13)
HansVogelaar pls correct me if wrong, SUMPRODUCT provides one output whereas MMULT provides column of outputs?
For Tax reporting, I need a column of months and next to it, column of CAD calculated.
Your second screenshot shows a single cell with a #VALUE! result. I guess I don't understand what you want.
Could you attach a small sample workbook demonstrating the problem (without sensitive data), and an indication of the desired output, or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?
