Spreadsheet: 784441d1655736255-how-to-add-month-by-month-to-get-ytd-using-getpivotdata-in-google-sheet-how-to-sum-vlookup
Sheet: Cost1

Current formular
IFERROR((IFERROR((VLOOKUP($BQ$5,$BB$20:$BO$24,14,FALSE))+(VLOOKUP($BQ$5,$BB$29:$BO$33,14,FALSE))
+(IFERROR(GETPIVOTDATA($BO$7,$BB$7,$BB$7,$BQ$5),0)),"0"))* will  multiple by some VLOOKUP
Direct Cost 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Direct Cost 1
cost centres | SUM of April | SUM of May | SUM of June | SUM of July | SUM of Aug | SUM of Sept | SUM of Oct | SUM of Nov | SUM of Dec | SUM of Jan | SUM of Feb | SUM of March | SUM of TOTAL |  |  | Row Labels | Sum of SUM of April | Sum of SUM of May | Sum of SUM of June | Sum of SUM of July | Sum of SUM of Aug | Sum of SUM of Sept | Sum of SUM of Oct | Sum of SUM of Nov | Sum of SUM of Dec | Sum of SUM of Jan | Sum of SUM of Feb | Sum of SUM of March | Sum of SUM of TOTAL
Product 1 | 8571 | 9221 | 9541 | 4626 | 6726 | 5564 | 4378 | 5478 | 2869 | 8168 | 4108 | 6362 |  |  |  | Product 1 | 8571 | 9221 | 9541 | 4626 | 6726 | 5564 | 4378 | 5478 | 2869 | 8168 | 4108 | 6362 | 75612
Product 2 | 8967 | 6031 | 8099 | 3025 | 4125 | 6815 | 6750 | 2605 | 5762 | 8093 | 7911 | 9626 |  |  |  | Product 2 | 8967 | 6031 | 8099 | 3025 | 4125 | 6815 | 6750 | 2605 | 5762 | 8093 | 7911 | 9626 | 77809
Product 3 | 6514 | 5936 | 5680 | 8987 | 8266 | 6823 | 9391 | 8028 | 4672 | 3982 | 8039 | 4318 |  |  |  | Product 3 | 6514 | 5936 | 5680 | 8987 | 8266 | 6823 | 9391 | 8028 | 4672 | 3982 | 8039 | 4318 | 80636
Product 4 | 4072 | 8040 | 7331 | 8748 | 9476 | 7030 | 7669 | 4775 | 3316 | 7485 | 5264 | 7264 |  |  |  | Product 4 | 4072 | 8040 | 7331 | 8748 | 9476 | 7030 | 7669 | 4775 | 3316 | 7485 | 5264 | 7264 | 80470
Product 5 | 6158 | 5015 | 3579 | 3306 | 8319 | 9361 | 4328 | 3251 | 8589 | 4009 | 9034 | 8755 |  |  |  | Product 5 | 6158 | 5015 | 3579 | 3306 | 8319 | 9361 | 4328 | 3251 | 8589 | 4009 | 9034 | 8755 | 73704
Product 6 | 9165 | 5076 | 2808 | 9358 | 7173 | 4212 | 4056 | 6976 | 9119 | 7006 | 7793 | 9104 |  |  |  | Product 6 | 9165 | 5076 | 2808 | 9358 | 7173 | 4212 | 4056 | 6976 | 9119 | 7006 | 7793 | 9104 | 81846
Product 7 | 8460 | 2758 | 4428 | 3933 | 5784 | 2881 | 5145 | 8767 | 6491 | 3142 | 3513 | 7790 |  |  |  | Product 7 | 8460 | 2758 | 4428 | 3933 | 5784 | 2881 | 5145 | 8767 | 6491 | 3142 | 3513 | 7790 | 63092
Grand Total |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Grand Total | 51907 | 42077 | 41466 | 41983 | 49869 | 42686 | 41717 | 39880 | 40818 | 41885 | 45662 | 53219 | 533169
Indirect Costs 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Indirect Costs 1
Indirect Costs | SUM of April | SUM of May | SUM of June | SUM of July | SUM of Aug | SUM of Sept | SUM of Oct | SUM of Nov | SUM of Dec | SUM of Jan | SUM of Feb | SUM of March | SUM of TOTAL |  |  | Row Labels | Sum of SUM of April | Sum of SUM of May | Sum of SUM of June | Sum of SUM of July | Sum of SUM of Aug | Sum of SUM of Sept | Sum of SUM of Oct | Sum of SUM of Nov | Sum of SUM of Dec | Sum of SUM of Jan | Sum of SUM of Feb | Sum of SUM of March | Sum of SUM of TOTAL
Product 1 | 5607 | 6761 | 7086 | 6513 | 7875 | 7267 | 5056 | 7114 | 5806 | 5019 | 5832 | 7142 |  |  |  | Product 1 | 5607 | 6761 | 7086 | 6513 | 7875 | 7267 | 5056 | 7114 | 5806 | 5019 | 5832 | 7142 | 77078
Product 2 | 5171 | 6375 | 6528 | 6129 | 5855 | 7280 | 5735 | 7220 | 8277 | 7626 | 5878 | 5942 |  |  |  | Product 2 | 5171 | 6375 | 6528 | 6129 | 5855 | 7280 | 5735 | 7220 | 8277 | 7626 | 5878 | 5942 | 78016
Product 3 | 6108 | 7199 | 8394 | 5048 | 5656 | 5925 | 6734 | 5101 | 6990 | 7442 | 7880 | 7722 |  |  |  | Product 3 | 6108 | 7199 | 8394 | 5048 | 5656 | 5925 | 6734 | 5101 | 6990 | 7442 | 7880 | 7722 | 80199
Product 4 | 7978 | 6698 | 6884 | 7211 | 5184 | 5013 | 6663 | 6087 | 7851 | 7781 | 8286 | 8286 |  |  |  | Product 4 | 7978 | 6698 | 6884 | 7211 | 5184 | 5013 | 6663 | 6087 | 7851 | 7781 | 8286 | 8286 | 83922
Product 5 | 6662 | 6286 | 7185 | 5063 | 7132 | 6676 | 6613 | 5982 | 7676 | 6161 | 7898 | 5929 |  |  |  | Product 5 | 6662 | 6286 | 7185 | 5063 | 7132 | 6676 | 6613 | 5982 | 7676 | 6161 | 7898 | 5929 | 79263
TOTAL |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Grand Total | 31526 | 33319 | 36077 | 29964 | 31702 | 32161 | 30801 | 31504 | 36600 | 34029 | 35774 | 35021 | 398478
Indirect Costs 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Indirect Costs 2
Indirect Costs | SUM of April | SUM of May | SUM of June | SUM of July | SUM of Aug | SUM of Sept | SUM of Oct | SUM of Nov | SUM of Dec | SUM of Jan | SUM of Feb | SUM of March | SUM of TOTAL
Product 1 | 3403 | 3125 | 4643 | 3366 | 4892 | 4814 | 5508 | 4936 | 4036 | 4075 | 3100 | 4552 |  |  |  | Row Labels | Sum of SUM of April | Sum of SUM of May | Sum of SUM of June | Sum of SUM of July | Sum of SUM of Aug | Sum of SUM of Sept | Sum of SUM of Oct | Sum of SUM of Nov | Sum of SUM of Dec | Sum of SUM of Jan | Sum of SUM of Feb | Sum of SUM of March | Sum of SUM of TOTAL
Product 2 | 4611 | 3659 | 5569 | 3353 | 4895 | 5035 | 3395 | 3926 | 5174 | 3147 | 4497 | 3526 |  |  |  | Product 1 | 3403 | 3125 | 4643 | 3366 | 4892 | 4814 | 5508 | 4936 | 4036 | 4075 | 3100 | 4552 | 50450
Product 3 | 3812 | 5499 | 5302 | 3304 | 3312 | 5563 | 5444 | 4960 | 4629 | 5181 | 3799 | 5226 |  |  |  | Product 2 | 4611 | 3659 | 5569 | 3353 | 4895 | 5035 | 3395 | 3926 | 5174 | 3147 | 4497 | 3526 | 50787
Product 4 | 5448 | 5275 | 4479 | 3205 | 4816 | 4563 | 5391 | 3487 | 4899 | 4502 | 5460 | 3556 |  |  |  | Product 3 | 3812 | 5499 | 5302 | 3304 | 3312 | 5563 | 5444 | 4960 | 4629 | 5181 | 3799 | 5226 | 56031
Product 5 | 3801 | 3664 | 5105 | 3481 | 3468 | 4703 | 5027 | 3976 | 3826 | 4981 | 3217 | 4745 |  |  |  | Product 4 | 5448 | 5275 | 4479 | 3205 | 4816 | 4563 | 5391 | 3487 | 4899 | 4502 | 5460 | 3556 | 55081
TOTAL |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Product 5 | 3801 | 3664 | 5105 | 3481 | 3468 | 4703 | 5027 | 3976 | 3826 | 4981 | 3217 | 4745 | 49994
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Grand Total | 21075 | 21222 | 25098 | 16709 | 21383 | 24678 | 24765 | 21285 | 22564 | 21886 | 20073 | 21605 | 262343
IFERROR((IFERROR((VLOOKUP($BQ$5,$BB$20:$BO$24,14,FALSE))-14 is the total column on my original data-am looking to add columns 2 &3 which is April and May
(VLOOKUP($BQ$5,$BB$29:$BO$33,14,FALSE))- 14 is the total column on my original data-am looking to add columns 2 &3 which is April and May
(IFERROR(GETPIVOTDATA($BO$7,$BB$7,$BB$7,$BQ$5),0)),"0"))-BO is the total column on my original data-am looking to add columns BC & BD which is April and May
Requirement please
how can I use wrap sum into vlookup to sum April and May to have the ytd costs for cost centre 1 etc
how can I use wrap sum into getpivotdata for April and May to have the ytd costs for cost centre 1 etc
and add vlookup+vlookup + getpivotdata to arrive at the ytd cost for both months
To add direct cost,indirect cost1 and indirect cost 2
 | Ytd Cost/current total costs
Product 1 |  | manual approach for April only-assuming I have to do this from June to March 23, I'll be adding every month-  I would like to wrap sum into getpivotdata to add both April & May to get total to Product 1 Ytd
Product 2
Product 3
Product 4
Product 5
Product 6
Product 7