In a bank stmt, an a/c No,amount,in different rows.How can I merge and add amount

**haris0471** · 06-24-2020, 02:36 AM

In a bank statement , one person's a/c No Name,mobile number ,amount to be paid ,in different rows.How can I merge and add amount and display in a row

**alansidman** · 06-24-2020, 02:53 AM

Please read the yellow banner at the top of this page on how to attach a file.

**haris0471** · 06-24-2020, 03:18 AM

statement attached.

**alansidman** · 06-24-2020, 03:29 AM

In P2 =SUMIFS($G$3:$G$17,$B$3:$B$17,K3) and copy down.

In a bank stmt, an a/c No,amount,in different rows.How can I merge and add amount

LinkBack

Thread Tools

Rate This Thread

Display

In a bank stmt, an a/c No,amount,in different rows.How can I merge and add amount

Re: In a bank stmt, an a/c No,amount,in different rows.How can I merge and add amount

Re: In a bank stmt, an a/c No,amount,in different rows.How can I merge and add amount

Re: In a bank stmt, an a/c No,amount,in different rows.How can I merge and add amount

Thread Information

Users Browsing this Thread

Similar Threads

Date and amount not printing exact place on bank cheque

[SOLVED] Bank reconciliation/matching negative with positive amount using VBA

Very large amount of vertical rows and horizontal columns. Need to merge it into 1 column

[SOLVED] Calculate Projected Annual amount from Dollar value (Amount) and varying time intervals

[SOLVED] Need to find a negative amount and match it to the positve amount based on Acct# and Date

Merge Duplicate Rows unique values into single rows for an infinite amount of columns/rows

How to keep record of balance on each amount withdrawn from a bank account opperation

Bookmarks

Bookmarks

Posting Permissions