Hi,
The SumIfs formula with duplicate criteria is working fine, however, the result is coming on the first count, how can we bring this result to the max count of the same subset.
Any help will be highly appreciated.
thanks
aleem
The SumIfs formula with duplicate criteria is working fine, however, the result is coming on the first count, how can we bring this result to the max count of the same subset.
Any help will be highly appreciated.
thanks
aleem
Results | Lookup Data | |||||||
Cust no. | Cust. Name | Amount | Doc Number | G/L Date | LT 1 Amount | Cust no. | ||
806290 | David Miller | (15,000.00) | <--IF(COUNTIF($A$3:A3,A3)=1,SUMIFS(H:H,I:I,A3),0) | 10001816 | 10.01.11 | (10,000.00) | 806290 | |
806290 | David Miller | - | 15000341 | 16.05.16 | (5,000.00) | 806290 | ||
806290 | David Miller | - | 19054479 | 26.01.20 | 10,000.00 | 806290 | ||
806290 | David Miller | - | 12004480 | 26.01.20 | 5,000.00 | 806290 | ||
806290 | David Miller | - | 21004479 | 26.01.20 | (10,000.00) | 806290 | ||
806290 | David Miller | - | 23004480 | 26.01.20 | (5,000.00) | 806290 | ||
806290 | David Miller | - | 10001819 | 11.01.11 | (5,000.00) | 807263 | ||
806290 | David Miller | - | <--Desired Result --The sumifs result should come here | 15000344 | 17.05.16 | (2,500.00) | 807263 | |
19054482 | 27.01.20 | 5,000.00 | 807263 | |||||
807263 | Tim Pane | (5,000.00) | 12004483 | 27.01.20 | 2,500.00 | 807263 | ||
807263 | Tim Pane | - | 21004482 | 27.01.20 | (5,000.00) | 807263 | ||
807263 | Tim Pane | - | ||||||
807263 | Tim Pane | - | <--Desired Result --The sumifs result should come here | |||||