Sumifs formula not showing correct result, one of criteria is from pivot table

Hi
I have created macro to create a pivot tbale.
To the right hand side of pivot table, I am creating 3 columns using sumifs formula.
One of the criteria for sumifs formula is column from pivot table. Sum range and criteria range are from the same data soucrce which I am using to create pivot table.
Once I fill down the formula, I get the same value as in first row where I start entering formula.
I am doing this in macro.
Please help.

HI,
I had my calculation option set to manual.
Which created problem
Thank you.