# Unique from A and sum each row from 3rd Column

1. ## Unique from A and sum each row from 3rd Column

Hi,

I am looking for a small and sweet formula that does the work.Existing formula is in A9 with correct result but the current formula seems to be very vast.Is there any alternative to it.

2. ## Re: Unique from A and sum each row from 3rd Column

One way,

``Please Login or Register  to view this content.``

3. ## Re: Unique from A and sum each row from 3rd Column

Hi, thanx for the reply.Can u explain me what does 'z',x,y represent ?including LAMBDA,REDUCE function here ?

5. ## Re: Unique from A and sum each row from 3rd Column

Ok.Now I am using another function representing above formula as 'f' and using below formula now which is
LET(f,F10:F12,SORTYBY(f,XMATCH(INDEX(f,,1),TOCOL(Sheet2!D2:D35,1))))
So how to merge into one single formula.

Note:F10:F12 is the resulting figure from above attachment.Secondly Sheet2 is not reflected as it is simply using Sortby and it's refrences.

6. ## Re: Unique from A and sum each row from 3rd Column

There is no sheet 2 in the sample attached to post #1.

7. ## Re: Unique from A and sum each row from 3rd Column

Ok I will attach it.

8. ## Re: Unique from A and sum each row from 3rd Column

OK - not there yet.

9. ## Re: Unique from A and sum each row from 3rd Column

Ok.Kindly find in attachment.

Two formula 1st is at A9 from above forum contributor & 2nd is at A14.Kindly produce a single formula to get result which is below A14.

10. ## Re: Unique from A and sum each row from 3rd Column

Like this:

``Please Login or Register  to view this content.``

11. ## Re: Unique from A and sum each row from 3rd Column

No,its not like that.You haven't touched Sheet2.

Pls see first in A15:A17-1st is Orange then Apple then Grapes as per the pattern in Sheet2!D2:D7 whichever do exists in Sheet1 and Grand Total at last if possible.

12. ## Re: Unique from A and sum each row from 3rd Column

Try this:

``Please Login or Register  to view this content.``

If you want solutions to work with 2021 and above, remove 365.

13. ## Re: Unique from A and sum each row from 3rd Column

I didn't mean to hurt you or any one If it does then I am extremely sorry for that.You all of you are real mentor to me and there are no any other words that I can express it for immense contribution here.

14. ## Re: Unique from A and sum each row from 3rd Column

If that takes care of your original question, please choose Thread Tools from the menu link above and mark this thread as SOLVED. You can also access the SOLVED tag by editing the opening post and choosing SOLVED from the drop-down to the left of the title box.

Also, if you have not already done so, remember that you can reward anyone who offered you help towards a solution for your issue by clicking the small star icon (* Add Reputation) located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of each of those who offered help.

15. ## Re: Unique from A and sum each row from 3rd Column

Please sign off the thread as requested in post #14 - I presume you are now satisfied with the solution?

16. ## Re: Unique from A and sum each row from 3rd Column

Thank you so much. Yes it has definitely worked.

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1