Forum Discussion
formula help please
i need a formula please if someone can help my columns are below transaction description Debit Credit Balance Account transfers Stock & dog purchases animal health AT ...
It's better to keep summary by expenses in separate table or create PivotTable on general ledger to have such. Anyway, with such data layout you first need to map transaction descriptions in first column on column names, like here in right range
With that formula in F3 could be
=($C3+$D3)*IFNA((INDEX($K$3:$K$5,MATCH($B3,$J$3:$J$5,0))=F$2),0)and drag it to the right and down.
Even better to use Excel Tables to be more dynamic with data ranges.