Hi everyone,
Hope you can help, I created an entry tab with 4 columns of data that gets sorted and entered into another tab called unique, this basically filters down column A and sorts it numerically and shows the totals for column B,C & D relating to the certain number in A1, A2 etc. (Screenshot below,)
The Formula's I have used in the unique tab on the right are
Cell A2 =SORT(UNIQUE(Entry!A2:A1048576))
Cell B2 =SUMIFS(Entry!B$2:B$1048576,Entry!A$2:A$1048576,Unique!A2)
Cell C2 =SUMIFS(Entry!C$2:C$1048576,Entry!A$2:A$1048576,Unique!A2)
Cell D2 =SUMIFS(Entry!D$2:D$1048576,Entry!A$2:A$1048576,Unique!A2)
and dragged the formula down in cells B,C, & D
This all works fine but now I need to add 2 more columns in as per below
I need the unique tab to work as it did before but also filtering column B & C aswell as Column A.
I have changed the formula in Cell A2 to =SORT(UNIQUE(Entry!A2:C1048576)) so it sorts columns A,B & C. (not sure if this is the best way to do it)?
But I need to know what to change the formulas in B2,C2,D2 etc as it is looking at Column A and adding the net weight, gross weight & value up everytime it see's the same number in column A. I need it to work it out correctly, I have done a manual example below of how it should look when its worked out correctly.
Help please.
Thank you
Hope you can help, I created an entry tab with 4 columns of data that gets sorted and entered into another tab called unique, this basically filters down column A and sorts it numerically and shows the totals for column B,C & D relating to the certain number in A1, A2 etc. (Screenshot below,)
The Formula's I have used in the unique tab on the right are
Cell A2 =SORT(UNIQUE(Entry!A2:A1048576))
Cell B2 =SUMIFS(Entry!B$2:B$1048576,Entry!A$2:A$1048576,Unique!A2)
Cell C2 =SUMIFS(Entry!C$2:C$1048576,Entry!A$2:A$1048576,Unique!A2)
Cell D2 =SUMIFS(Entry!D$2:D$1048576,Entry!A$2:A$1048576,Unique!A2)
and dragged the formula down in cells B,C, & D
This all works fine but now I need to add 2 more columns in as per below
I need the unique tab to work as it did before but also filtering column B & C aswell as Column A.
I have changed the formula in Cell A2 to =SORT(UNIQUE(Entry!A2:C1048576)) so it sorts columns A,B & C. (not sure if this is the best way to do it)?
But I need to know what to change the formulas in B2,C2,D2 etc as it is looking at Column A and adding the net weight, gross weight & value up everytime it see's the same number in column A. I need it to work it out correctly, I have done a manual example below of how it should look when its worked out correctly.
Help please.
Thank you