How to aggregate AMOUNT into NEW AMOUNT according to PART Code?

**Sakurayuki** · 09-27-2020, 03:15 AM

example

Before B2 to B9 are blank, they belong to the B2 range, and then the AMOUNT which belongs to this range E2:E8 data is summarized and written in the new column F

Can someone please help me ? It would be much appreciated. Thanks in advance

**jindon** · 09-27-2020, 05:04 AM

Try

Please Login or Register  to view this content.

返信の際、機械翻訳した日本語訳は無用です。

**Sakurayuki** · 09-27-2020, 05:12 AM

Excellent solution. Thank you Jindon teacher

How to aggregate AMOUNT into NEW AMOUNT according to PART Code?

LinkBack

Thread Tools

Rate This Thread

Display

How to aggregate AMOUNT into NEW AMOUNT according to PART Code?

Re: How to aggregate AMOUNT into NEW AMOUNT according to PART Code?

Re: How to aggregate AMOUNT into NEW AMOUNT according to PART Code?

Thread Information

Users Browsing this Thread

Similar Threads

[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

Calculate an end date for fixed amount of work by a variable amount of monthly effort

[SOLVED] Folder has X amount of jpeg files. How to automate creating links for those X amount of fi

[SOLVED] In pivot match vertical row amount with the horizontal column -amount and highlight that

How can I calculate amount of time left based on amount spent?

Sum a $ amount in part of a field

Bookmarks

Bookmarks

Posting Permissions