I am trying to add the values in Col B pertaining to the transacation Type in Col G as well as to the account Number in Col A for the Criteria "Sales" i.e I am trying to sum the value in Col B, relating to "sales" for a particular number in Col A for eg account 12518

'=SUM(SUMIFS('[BR1 Vat Extraction .Oct 2012.Fin1.xlsm]Pivot Output'!$B:$B,'[BR1 Vat Extraction .Oct 2012.Fin1.xlsm]Pivot Output'!$G:$G,'[BR1 Vat Extraction .Oct 2012.Fin1.xlsm]Pivot Output'!$G:$G),'[BR1 Vat Extraction .Oct 2012.Fin1.xlsm]Pivot Output'!$A:$A,'[BR1 Vat Extraction .Oct 2012.Fin1.xlsm]Pivot Output'!$G:$G,"Sales")

See Source File Below

Excel Workbook | |||||||||
---|---|---|---|---|---|---|---|---|---|

A | B | C | D | E | F | G | |||

1 | 12301 | -2000 | COS | ||||||

2 | 12515 | 9708.2 | COS | ||||||

3 | 12518 | 96 | Sales | ||||||

4 | 12610 | -88373 | COS | ||||||

5 | 13050 | 126119.7 | COS | ||||||

6 | 13110 | 38256.39 | Sales | ||||||

7 | 13300 | 700739.5 | COS | ||||||

8 | 13305 | 0 | COS | ||||||

9 | 13310 | -4000 | Sales | ||||||

10 | 13350 | 0 | COS | ||||||

11 | 13410 | -2925.5 | Sales | ||||||

12 | 13605 | 251.94 | COS | ||||||

13 | 13610 | 0 | COS | ||||||

Sheet1 |