Friends,

I have a pivot table, with field names - "for months", "Ref No", "Grand Total", etc (This pivot table is from D5:Z100 - changes as and when we filter the pivot as per our data requirement).

I just want to write a formula outside Pivot Table in Column A5, like =SUMIF("Column Ref No","400","Grand Total").

That is if, there are value of in "400" in "Ref No" column, then sum the related values in column "Grand Total".

Pl help me.