Forum Discussion
How to get the Account code from the formula refer the amount column
Hi, I have 2 sheets in workbook. 1st sheet is Summary sheet and other one is details sheet. I have attached the sample sheet with required result in highlighted cells, 1st sheet having the sa...
Try this:
=SUM(MMULT(TRANSPOSE(Details!$F$4:$F$14),--(Details!$B$4:$B$14=E4:J4)))Entered in D4 of the attached file and copied down.
Thank you for the reply I want the accounts no which is highlighted in summary sheet.
Sorry, but i don't understand.
I want the for PPE which are the accounts added to for the value. i.e. 1001 - 1008 which is highlighted.
Still don't understand. I assumed you wanted a formula that calculated 1250 for PPE, based on the account numbers mentioned. Isn't that correct?
