How to get the Account code from the formula refer the amount column

Question

Hi,&nbsp;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,&nbsp;1st sheet having the sample balance sheet where it summarizes the accounts amounts from the details sheet. i want the account number in 1st sheet against group of balance sheet accounts as per the amount total.&nbsp;Thank you in advance&nbsp;Tejas Shah&nbsp;

riny_van_eekelen · Answer

Tejas_shah&nbsp;Try this:=SUM(MMULT(TRANSPOSE(Details!$F$4:$F$14),--(Details!$B$4:$B$14=E4:J4)))&nbsp;Entered in D4 of the attached file and copied down.

tejas_shah · Answer

Thank you for the reply I want the accounts no which is highlighted in summary sheet.

riny_van_eekelen · Answer

Tejas_shah&nbsp;Sorry, but i don't understand.

tejas_shah · Answer

Riny_van_Eekelen&nbsp;&nbsp;&nbsp;I want the for PPE which are the accounts added to for the value. i.e. 1001 - 1008 which is highlighted.&nbsp;

riny_van_eekelen · Answer

Tejas_shah&nbsp;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?

Forum Discussion

How to get the Account code from the formula refer the amount column

Resources